Custom Data Setup allows you to use an accessible feature layer in the Business Analyst web app. An accessible feature layer is one that has been shared publicly, or shared with you by another user. It is a published feature layer along with some metadata of how to statistically apportion or calculate numeric data. The metadata file is stored in your ArcGIS Online or ArcGIS Enterprise organization as an item type called a Data Collection.
To get started with adding custom data you can follow the Step-by-step guide below. You will see how to add data by browsing services hosted on ArcGIS Online. There is a section showing you how to enter a service url directly to add the custom data.
The Custom Data Setup workflow allows you to easily add your own data and use them along with Esri Demographics data. The following step-by-step guide will help you to get started with adding feature layers that you can use in your projects and share with others in you organization. After you have added your layer you will create a color-coded map from one of the layer's variables.
To get started you will need to open the Maps tab.
- Navigate to Maps > Add Data > Custom Data Setup.
The Custom Data Setup dialog opens on the left. In the table, the My data tab lists all the data layers added previously. You may click on Data shared with me to see the data layers shared by other users.
- Click Start Setup. Expand the Choose Layer drop-down menu. Select from the following options to add a layer:
- Browse for a layer allows you to select from available layers in ArcGIS Online.
- Layer from Project will open the Select Layer dialog, which allows you to select a layer from the current project.
This option will not appear if your current project does not have any layers that can be added.
- Enter URL allows you to directly type in a layer URL in the Enter a URL for a layer field.
- Click Browse for a layer.
The Select a Layer dialog opens and the My content tab is open by default, which shows all web maps and feature services created by you. You can also browse the content in the other tabs. This experience will be very similar to selecting a web map or layer in the Web Maps and Layers workflow.
- From the tabs available, click ArcGIS. In the search field, type Toys and click Search.
- Click My groups to see the groups you have access to. This includes groups that other users invited you to, and you joined. You may select a layer to add. Groups in ArcGIS Online correspond to Projects in the Business Analyst Web app. See Shared Projects.
- Click My content to view a list of your services and layers in ArcGIS Online. You may select a layer to add it.
- Click My organization to view content created and shared by other users in your organization.
- Click Living Atlas to see content from ArcGIS Living Atlas of the World.
- Click ArcGIS to see content publicly shared on ArcGIS Online.
- Enter a search term in the Search for services by title or enter a URL or ID field, and click the Search button. You may then select a layer from the search results.
You may move the pointer over the SF_Coffee_Toys_Sales_HM service to view information and options for that feature service.
- Click Add.
The Select a layer dialog opens, displaying the available layers in the selected feature service.
- Click ToySales.
The layer will be imported in the workflow.
- Click Setup Custom Data.
The Setup Custom Data dialog opens.
- Click the Edit button to edit the metadata for the category.
The Edit Custom Category dialog opens.
You can update the Title, Summary, Description, Tags and the Icon for the category. To update the icon image, you can use one of these options:
- Shape or Icon—Select a shape or icon from the available list.
- Browse for image—Browse for an image on your computer and upload it.
- Image from URL—Provide a URL for an image.
- When done, click Apply and click Open. The layer is open for setup.
The variables in the layer are listed on the left, and the categories on the right. The layer name ToySales will be the default category name.
- To rename the category, click the options icon and then click Rename.
- Click Add subcategory.
The Add Subcategory dialog opens.
- Enter a name for the subcategory and click Create.
Create two subcategories: Toy Sales 1st half of Yr, Toy Sales 2nd half of Yr.
- In the Setup Custom Data window, click the Variable table link.
The Variable table view is displayed.
You can drag and drop the variables on the left into any category or subcategory, but first you will view and edit them in the Variable table tab.
In the Variable column header, you can click to search for a variable by name. Click to configure properties all the variables together, except the names. Click next to a variable to individually edit its name and properties in the Configure Variable dialog.
- Display Name—Set the variable name that is shown in the data browser.
- Vintage—Set the vintage year that is shown in the info icon in the data browser.
- Summary Type—Defines the way aggregated values are summarized.
- Sum—Adds up aggregated values for the polygons that intersect the target area.
- Average—Averages aggregated values for the polygons that intersect the target area.
- Weight—An additional parameter for when Summary Type is Average that defines which field to use to get the weighted sum. When Average is not selected as the Summary Type, None will automatically be selected for Weight and vice versa.
When you have a variable for a median or proportional value in your data, the weighted average is useful for determining the value of that variable across multiple areas. For example, data related to an awareness campaign by ZIP Code. The penetration rate is the proportion of population for an area that is informed about the target issue of the campaign. You will also need to have a variable for Population in your dataset. To determine the overall penetration rate across all the areas, a weighted average can be calculated, which uses the following formula:
Area Penetration rate Population Penetration rate * Population
(0.5 * 24,000) = 12,000
(0.7 * 12,000) = 8,400
(0.4 * 30,000) = 12,000
(0.2 * 35,000) = 7,000
(0 * 18,000) = 0
Sum(Population) = 119,000
Sum(Penetration rate * Population) = 39,400
- Apportionment Method—An additional parameter for when Summary Type is Sum, that defines how a variable is weighted to a portion of geography. When Sum is not selected as the Summary Type, None will automatically be selected for Apportionment Method and vice versa.
- Population—Weight is based on the value representing the probability of a population at a certain point.
- Area—Weight is based on the area of intersection between the target area and the data polygon.
- Type—Drop-down change Double to Decimal.
- Units—Defines the unit of the data value for its use in mapping, analysis, and reporting.
- Category—Set the Data Browser category in which the variable will appear.
- Subcategory—Set the Data Browser subcategory in which the variable will appear.
- When done, click Apply.
- Click the Customize Data Browser link.
The Customize Data Browser view is displayed. You can use Shift + click or Ctrl + click to select multiple variables and drag them from the left to any category, or subcategory, on the right. You can also drag them between categories and subcategories on the right.
You can immediately launch one of the workflows where you can use the variables you just added, by finding them under the My Data tab in the Data Browser.
- Click I'm Done.
The data just added will be listed under My Data.
- Click the options icon to access the following options:
- Edit—open the custom data layer in the Setup Custom Data dialog. To edit it, move the pointer over the thumbnail and click the Edit button.
- Share—use the Share Custom Data dialog to select other users in your Organization or Groups and share this custom data layer with them.
- Disable—make the custom data layer unavailable for use. You will need to Enable it again.
- Remove—Permanently remove the custom data layer. To use a custom data layer again, you will need to add it using the Custom Data Setup workflow
- View metadata—view the metadata for the layer. You can edit the metadata using the Edit option.
- Variables may be applied for mapping or comparison only if they are associated with a polygon feature layer. Variables associated with a point layer are supported in Comparison reports, but not available for mapping.
- If the Disable option for a data layer is applied, the layer will not be present in the Data Browser.
Create color-coded map from custom data layer
You may now access your custom data via the Data Browser for use in the Business Analyst Web app. Here, we will demonstrate using this custom data layer in Color-coded maps.
Navigate to Create Maps from Data > Color Coded Maps > Browse all variables to open the Data Browser. Click on the My data tab (this tab is available only when you have added custom data).
You may also browse data others in your organization have shared with you, which will be under the category Data shared with me.
- Click My data.
The variables in your added Toy Sales data layer will be available here.
- Click Toy Sales Q1 to create a color-coded map for that variable.
The resultant map is displayed.
Add data by entering a URL
Let us now add data directly by entering a URL. An example would be to use a feature service on ArcGIS Online that has data layers that can be added to the web app and setup.
- Click the Choose Layer drop-down menu, then click Enter URL.
A field appears in the dialog.
- Enter the URL in the field and click Go.
The Select a Layer dialog opens.
- Click any layer that is shown.
The layer is imported.
- To add the layer and set it up, click Setup Custom Data.
The Setup Custom Data dialog opens, with the variables from the layer available and a default category created for them. To set up your data you will follow the steps above starting from Step 7.
Create comparison report
You will now generate a comparison report for two sites, using your newly added data, which will be apportioned for use in the comparison report, in the same way that other variables in the Business Analyst Web app are apportioned.
Go to Reports > Comparison Reports and select the sites in the carousel.
- Click Customize.
- Navigate to My data and select the custom data.
- Click View Table to generate the comparison report.