Trying to show a count of Unique values in Report

274
1
11-28-2022 09:16 AM
Labels (2)
AESNortheast1
New Contributor

I have been trying to do this for a few days now wityh no luck. I currently have a report showing a table of parcels that have been organized by a group for home age and showing water utility material. One of the statistics im trying to show in a text label is a count of how many of each unique utility material types are shown in the group. 

So something along the lines of this is what I'm trying to get from the report output:

Home Age Group: 1800 - 1899

Cast iron - 3

Ductile Iron - 2

Asbestos cement - 4

There doesn't seem to be an easy way to change/edit the dynamic text to do this function based on the group selection in the report. Any help would be appreciated.

For reference I am running the latest ArcPro software. 

Tags (3)
0 Kudos
1 Reply
DanLee
by Esri Regular Contributor
Esri Regular Contributor

If you don't have the count information in your table, you can try Summary Statistics with the Unique option to get the count in an output table.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/summary-statistics.htm

Then you would need to use Join Field to transfer the count field to your table via the common field, Home Age Group I guess.

0 Kudos