You are here:
About organizing report data
Mapping and visualization
Working with graphs and reports
This topic was updated for 9.3.1.
One advantage of displaying your data in a report is that a report allows you to organize your data. For example:
How to organize report data
- You can sort records based on the values in one or more —for example, given a list of cities, you could sort them by total population.
- You can group records together and calculate summary statistics. For instance, you could group cities by what country they're in.
- You can further calculate summary statistics—for example, compute the sum, average, count, standard deviation, and minimum and maximum values.
- Click the Sorting tab on the Report Properties dialog box.
- Click a field to sort in the Sort column.
- Click Ascending, Descending, or None.
- If you want to sort other fields, click them, then click the sorting method. ArcMap sorts the fields based on the sort order.
- You can sort records using up to three fields in ascending or descending order.
Calculating summary statistics
- Click the Grouping tab on the Report Properties dialog box.
- Double-click the field you want to use to group data.
- Click Grouping Intervals and click the method for grouping data.
- Click Ascending or Descending for the sort method.
- Check Include Group Fields to repeat the group value in the report display.
- Click the Summary tab on the Report Properties dialog box.
- Click the Available Sections drop-down arrow and click the section where you want the statistics to appear.
- Check the box that corresponds to the statistic you want to display for each numeric field.
- Repeat steps 2 and 3 to display statistics in each available section.
- You can compute the average, count, minimum, maximum, standard deviation, and sum for any numeric fields on your report.
- You can display summary statistics for a field at the end of the report, at the end of each page, and at the end of each group you've defined.
- To make the data in your reports easier to read, you can shade every other record with a color.
Please visit the Feedback
page to comment or give suggestions on ArcGIS Desktop Help.
Copyright © Environmental Systems Research Institute, Inc.