I have a Data Type called Runs. I want to generate a chart based on this. I want a stacked chart.
Each Run has these fields: Run_Dog, Run_Judge, Run_Status. Overall across the app there are many Run_Dogs and Many Run_Judges.
I want to create a stacked bar chart that has a bar for each judge and shows the count of the run_status for the selected dog. The dog is selected in a dropdown so the results are limited to the selected dog.
There are 3 Run_Status options (from an option set), Clear, Faults, and Eliminated.
For example, for dog Lassie,
Judge Joe Bloggs has 3 clear, 6 faults and 10 eliminated
Judge Sam Fox has 5 clear, 0 faults and 1 eliminated
Judge Neil Quin has 0 clear, 1 fault and 1 eliminated
etc
The data set for the x-axis would be
search for judges where judge_name is in judges dropdown
The Data set for Clear runs would need to be
3,5,0
The Data set for Faults would need to be
6,0,1
The Data set for eliminated would need to be
10,1,1
I can’t create these data sets
Can anyone point me in the right direction? I’ve tried all kinds of combinations, for example
Search for Runss(Type runs Run_Dog = Dogs Select Value): grouped by Run_Judge(Field 1 to group by Run_Judge Type Exact Aggregation 1 count):count
Just gives me the output of a single number not 19,6,2