Hi guys,
I'm trying to display the unique counts highlighted in red from two fields under the 'Symbology', unique values pane. I would preferably like to add them to the 'Contents' pane or add them to my label properties to display them on the map. They are the result of a one to many join from two tables. Is this even possible? Any pointers will be appreciated. Thanks.
Solved! Go to Solution.
I think what your looking for is to add a new field to the attribute table that holds the counts for each unique pairing of tract ID and Status. This can then be used in symbology or labeling.
A possible solution is to create a new text field to contain concatenated ID and Status field values with a visual delimiter such as a semicolon between values for easier reading something like (!TractID!+";"+!Status!); I'll call the field Conc. Then Summarize on field Conc setting the Statistics field to Conc --> Statistics Type to Count --> Case Field to Conc. This creates a new output table with the Count info you want that can then be joined back to the attribute table and extraneous fields cleaned up. Hope it works for you.
I think what your looking for is to add a new field to the attribute table that holds the counts for each unique pairing of tract ID and Status. This can then be used in symbology or labeling.
A possible solution is to create a new text field to contain concatenated ID and Status field values with a visual delimiter such as a semicolon between values for easier reading something like (!TractID!+";"+!Status!); I'll call the field Conc. Then Summarize on field Conc setting the Statistics field to Conc --> Statistics Type to Count --> Case Field to Conc. This creates a new output table with the Count info you want that can then be joined back to the attribute table and extraneous fields cleaned up. Hope it works for you.
I appreciate the solution. This worked out great! Exactly what I was looking for. Cheers!