A summary table can be used to show statistics—including sum, average, minimum, and maximum—for unique categorical groups, or numeric totals if you choose only number or rate/ratio fields to create the table. A summary table can provide multiple statistics—one for each numeric column.
You can copy a table card onto another page by dragging it to the New Page tab or an already created page. If you want to copy the table onto the same page, use Ctrl+C to copy and Ctrl+V to paste.
A summary table can only have one or two category columns. You can choose either a string or location field to provide unique categorical values for the column.
Create a summary table
You can create a summary table by selecting fields from the data pane or by changing the visualization type of an existing card.
To create a new summary table, select one or more fields and drag them to the Show Table drop zone or click Table above the data pane.
A summary table can contain only one or two category columns. You can select two or more numeric or rate/ratio fields to be summarized.
When using two category fields to create your summary table, the first category field you select becomes the first column of your summary table and groups your data in the table. If you wanted to find the sales per region within each state you would select state, region, and sales fields to create your table. If you accidentally selected region in the data pane first, you would then have a table grouped by region. You can then drag and drop the state column onto the first column to change the grouping field.
Data in a summary table can be organized using Sort Fields and by re-ordering columns. You can sort a single column, or sort multiple columns in the table using Shift+click on multiple fields. When using a grouped summary table, sorting occurs on the sorted column within the group. Columns can be re-ordered by clicking and dragging a column to a new position.
You can apply a card-level filter to your summary table if you want to remove unnecessary text, number, or date values. To apply a filter, click Card Filter on the summary table and choose the field you want to filter. You can apply multiple filters to the same table. Only data that meets the criteria for all filters will be displayed in the summary table.
Applying a card filter will not affect other cards using the same dataset.
Features in summary tables can be selected by clicking a single feature, by clicking and dragging the pointer over the desired features, or using Ctrl+click. The selected features will be represented in the summary table as well as other maps, charts, or tables displaying the same data. Once a selection has been made on a summary table, the following options will be available:
- Invert a selection—Click the Invert selection button to switch your selected features. The inverted selection will be reflected in all other cards displaying the same data.
- Show a selection—Click the Show selection button to show only your selected features in the summary table. The features that are not selected are temporarily removed from the summary table. The selected features will remain selected on all other cards displaying the same data, but no other changes will take place on those cards. You can show the unselected features again by clicking Show selection a second time. The selected features will remain selected until you click the scroll bar in the summary table or in another card.
Making a selection is different from applying a filter, because selections are more temporary and are reflected on all cards using the same dataset.
A summary statistic can be chosen for each number or rate/ratio field being summarized. The available statistics include sum, minimum, maximum, and average. The statistic will be calculated for each row on the summary table, as well as the entire dataset. The dataset statistic is displayed as a footer at the bottom of the summary table.
The dataset statistic is calculated using the raw dataset, rather than the values from the summary table. This distinction is most important for the average statistic. For example, if you have a dataset with 10,000 features and you create a summary table that has 5 rows, the dataset average will be calculated using all 10,000 features, rather than averaging the 5 rows displayed on the table.
Copy a table
A table card can be duplicated on a page by activating the card (a card is active when the Action button is visible) and using Ctrl+C to copy the card and Ctrl+V to paste it on the page.
Using copy and paste to duplicate cards is not supported in Microsoft Internet Explorer. For a list of other browsers that can be used, see Supported browsers.
A table card can be copied to a different page by dragging the card to the New Page tab or to an existing page. When a table is copied to a new page, the dataset will also be copied, if necessary, along with all of the processes used to create the table. The dataset will not be copied if it already exists on the new page unless one of the datasets contains a dataset filter, a calculated field, or a location field created by enabling location.