laptop and a wrench

Bug

In ArcGIS Insights (ArcGIS Online), the same values in a table view are aggregated, and the 'show all values' option is required for each column.

ArcGIS Insights
Bug ID Number BUG-000140718
SubmittedJune 15, 2021
Last ModifiedJune 5, 2024
Applies toArcGIS Insights
Version foundN/A
Operating SystemWindows OS
Operating System Version10.0
StatusAs Designed

Additional Information

This behavior is by design, and it is how the summary table works. The first and last aggregated columns before the statistic always show all the records if the higher cardinality (Granularity) column is added first. The middle columns that are grouped show blanks.

Workaround

Reorder the columns from lower cardinality to higher cardinality to achieve the most appropriate display on the summary table cards. This hides repeated records to declutter the display, and by scrolling down, the repeating record is shown in the first row.

Alternatively, show all the records by conducting the following steps:

  1. Create a summary table from the desired columns.
  2. From the result dataset (for example, Summary Table 1) in the data pane, create a reference table card using the desired columns that show all the records.
  3. Delete the summary table card (not the result dataset in the data pane) if not necessary.

Steps to Reproduce

Bug ID: BUG-000140718

Software:

  • ArcGIS Insights

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options