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

513
0
03-08-2023 07:15 AM
Labels (1)
Olwyn_Bruce
Occasional Contributor

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!

0 Kudos
0 Replies