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!