Create dashboard table with filtered attribute counts as well as total attribute counts

Olwyn_Bruce — Wed, 08 Mar 2023 15:15:57 GMT

Hi there,

I'm in the "going in circles" phase now...I have created a FeatureSet with two fields: DISTRICT and STATUS. Each DISTRICT has multiple entries for STATUS. There are 4 possible values for STATUS: A, B, C and D.

I'd like to display the following statistics in a table - the DISTRICT with a total count of STATUS plus a total count of just STATUS A+B+C.

I can use GroupBy to get the statistics for the total STATUS count with no issues (I don't even need a data expression for that). However, inserting the subset of STATUS counts (just the A+B+C) is proving to be tricky (for me!).

I've tried using an SQL CASE statement (eg. CASE WHEN STATUS <> D THEN COUNT(STATUS)) expression but so far, no luck. Suggestions welcome!

topic Create dashboard table with filtered attribute counts as well as total attribute counts in ArcGIS Dashboards Questions

Create dashboard table with filtered attribute counts as well as total attribute counts