Reports: Customized for One or Multiple Indicators

You can create a customized report that will suit your preferences and provide data for multiple indicators.

Create a Report

  1. Navigate to your area of interest.

  2. In the submenu click and select Advanced Report. The Advanced Report window displays.

  3. In the Report Title text field enter the Report Title. This is optional but highly recommended to give the report a meaningful identifier.

  4. Select the Geography for which you want to perform your analysis.

    NOTE:  The options available to select depend on the zoom level selected and the data you’ve licensed.

Geography Minimum Zoom Level
State 4
DMA 4
Congressional District 4
Metro Area 4
County 4
ZIP Code 5
Populated ZIP Code 5
Census Tract 8
Block Group 10
Block 14

 

  1. (Optional) Select the Add to Report check box to include the name of an additional higher level geography in report. Options listed depend on license and current geography selected. Custom Geography names may also be included in report when the selected geography is the same as the one used to define your custom uploaded geography.

  2. Select Year check box(es). Selection of years hides and reveals indicators displayed in the corresponding databases.

  3. Select Data Type, either counts and/or percentage check box. Selection of data type hides and reveals corresponding indicators.

  4. Under Indicator, click to expand American Marketscape DataStream, Consumer Spending Dynamix, User Defined or corresponding database .

  5. Click the plus to the to expand Groups. Continue to expand Groups until individual indicators display. Please refer to the GIS Reference Guide, for a list of all indicators or use the Search feature to locate desired information. Various symbols display next to indicators :

Symbol Description
Numeric indicator
Percentage indicator
Unlicensed indicator
Uploaded data indicator
Virtual indicator
Disabled numeric indicator because indicator is not available at the geography level currently selected
Disabled percentage indicator because indicator is not available at the geography level currently selected
Disabled uploaded data indicator because currently selected geography does not match data uploaded
Virtual indicator that has been shared with you

  1. Select your Indicators from the list then click Add to include the indicator in the Selected Indicator(s) list.

    NOTE:  Not all categories and indicators are available for all geographical levels and percentages. An example of this indicator is Total Population, which is only available for Counts but not for Percentages.

  2. Repeat steps 7 -10 until all information you need has been selected. A maximum of 30 indicators may be selected.

  3. To remove an indicator from the Selected Indicator(s) list box, select the indicator and click Remove.

  4. Click the up/down arrows to reorder the sequence of information needed for the report. The report displays in the same order that is seen in the Selected Indicator(s) box.

  5. Click Create Report to view data in tabular format.

  6. The system displays a window showing the data in grid form where you can sort it online or download to Microsoft Excel for further adjustments or printing.

  7. To sort the report in descending order, click on the column header you want the report to be sorted by. Click the column heading again to sort in ascending order.

  8. To swap columns and rows in the report window, at the bottom of the window click the Transpose icon.

    NOTE:  The transpose function only modifies the layout of report in the preview window, the report exports to Excel in original format.

  9. To export to Microsoft Excel, click the Download Report icon on the lower right.

  10. To save the report to your account for later retrieval from My Projects, click the Save Report icon on the lower right.

    NOTE:  Advanced report will also apply any conditional filters entered in Map Query. Parameters entered in Map Query will display below the Report Title.

Create User Defined Group with List of Selected Indicator

User-defined groups let you create your own virtual category by letting you group together indicators from different categories. This is a useful feature as it lets you save a set of indicators that you use often in analysis thus saving you time from having to select each individual one every time you run a report.

To create a user defined group with the indicators currently selected in the Advanced Report window:

  1. Click the Create User Group icon found above the Cancel button.

  2. The User Defined Group window displays. In the Group Name text box enter the name of your user-defined group.

  3. At the bottom of the window click Add to create your user-defined group.

What's Next:

Reports: Map Reports