Skip To Content

New comparison reports

New Comparison Reports allow you to create reports that compare your sites based on a set of popular categories. These popular categories include population, households, income, and housing as well as customizable reports. Options also include comparing your sites to a benchmark and neighboring geographies.

  1. Click Reports and click New Comparison Reports.

    The New Comparison Reports window opens, displaying your most recently used custom comparison report, or the Esri Population Comparison report for 2 preselected sites. These are the two sites most recently opened on the map. If there were no sites on the map, the two most recently used sites are preselected.

    Comparison reports window

    If any of the selected sites have multiple rings, drive times, or walk times, the smallest one is always selected by default. You may expand the drop down and select a different one. You can also check the Expand rings, drive time or walk time checkbox to view the data for all of them in the comparison table.

  2. Click the Switch rows and columns button to view the sites as columns and the data variables as rows.
  3. Click Add variables to add more variables to this custom comparison report (not available for Esri Comparison Reports).
  4. Click Edit to edit this custom comparison report (not available for Esri Comparison Reports).
  5. Click Create New Report to create a new custom comparison report.
  6. To export the data in the comparison table as an excel file, click Export.
  7. Click Chart to view the comparison as a chart.
    Chart view
  8. In the Chart view, you can move the pointer over any section of the chart to view tool tip values of the variables for the highlighted site.
  9. Click Print to print the chart.
  10. Click Export to export the chart data as an excel table.
  11. To modify the sites selected for the comparison, click Add sites.

    The Add Sites dialog opens.

    Add Sites window

  12. The Recent tab will be open by default, listing sites you recently created.
    • Select the checkbox for the sites that want to add to the comparison. To remove a site, deselect its checkbox.
    • Select the Site name checkbox to automatically select all sites in the current tab (not available on the From projects tab).
    • Click to Search sites search for sites by name.
  13. You can also add or remove sites from any of the other tabs:
    • Currently on map- where the sites currently open on the map are listed.
    • From projects- where you can add other sites from your current project, your other projects, or projects shared with you by other users.
    • Neighboring geographies- where you can select geographies and add them to the comparison table. The geographies available in each are based on the sites currently selected. This step alleviates the need to create geography sites just for comparison purposes. If you want to compare sites to a geography that is not automatically available here, you can create a geography site under Define Areas for Reports > Select Geography, and then select it for comparison. Each geography list is populated based on the sites you have selected. For example, for a point-based site, the County list includes the county where the point-based site lies. For a hand-drawn polygon, all counties that the polygon touches are added to the County drop-down.
      Add Sites window
    • Statistical comparisons- where you can select the Average and/or Median of Sites to add to the comparison.
      Statistical comparisons
  14. When done, click Apply.

    The Comparison table or chart will be updated with the data for the updated selection of sites, geographies and statistical comparisons.

    Table view

Create new comparison report

To create a new comparison report you will perform the following steps:

  1. Click Create New Report..
    Create New Report
  2. Enter a name for your new comparison report, and click Save.
    Enter report name
  3. To add variables to the report, click Add variables.
    Add variables

    The Add Variables dialog opens.

    Browse by category
    To search for variables, enter the search term in the search field, and click Search variables.

    To browse by category, click on any of the thumbnails. The variables in that category will be displayed.

    Spending variables
    • You can quickly select any of the Popular variables
    • To view variables in a subcategory, click on any of the options under Keep browsing.
    • You can click the Show all 'Spending' variables option to view a list of all variables in this category.
    • Click the Create your own 'Spending' variable option to launch Create Custom variable.

    Selected variables will be displayed on the right. When done selecting variables in this category, click Back to return to the previous screen and continue browsing by category, or by any of the other grouping options. Refine results further by keyword.

    Additional options:

    • Saved variables- your previously saved variables, including custom variables
    • Favorites- the variables you have marked as favorites
    • By source- Refine results further by data source e.g. Esri, US Census, American Community Survey (ACS), etc.
    • Show All- a complete list of all available variables. Refine results further by Year, Gender, Race, Source, etc.
      Refine variable search

    To save the current selection of variables, click Save List. You can also quickly add a previously saved list of variables to the current comparison from the Saved lists drop-down.

  4. When done selecting variables, click Apply.

    The comparison table will be updated with your selected variables.

    Updated table

  5. Click Chart to view the comparison as a chart.
    Chart with multi-axis display

    Count, Average and Index variables each have their own axis. Since these types of variables typically have values that differ by orders of magnitude, the separate axes for each helps more effectively visualize them in the chart.

  6. To Save this comparison, click Save. To open the comparison table in edit mode, click Edit.

    Edit mode
    Move the pointer over a row, or column header, and click Delete to delete it. The Click to drag symbol indicates that you and click and drag the row or column to change its position. To close the Edit view, click Edit.
    Edit mode is not available in Chart view

Make Benchmark

In the Comparison table, you can click on See additional options next to a site, geography or statistical to see additional options.

Make Benchmark

Click Make Benchmark to give it greater visual prominence as the highlighted first column. This is useful when one of your sites is a standard or point of reference against which you want to compare other sites.

Updated table showing benchmark

Arrow indicators in each cell, pointing up or down, indicate whether its value lies above or below that of the corresponding benchmark.

The cells are colored according to the color ramp on the right, applied to the range of percent differences between the cell values and the corresponding benchmark value. Click on any color in the ramp on the right to replace it with a different color from the palette and dynamically update the table. Click Save colors to save the set of colors as a ramp under Preferences.

By default, the values here are classified by intervals with equal counts (quintile method). To modify the class break values, click Edit ranges and then click in any of the percent values and enter a modified value. You can also click of the color cells to modify the color. When done, click Back.

Edit ranges

When you click Export to export the benchmarked table as an Excel file, the styling is not preserved.