I have a data thing called run, and each run has a judge. Each runs has a status (Clear, Faults, Eliminated).
I want to have a chart that has all the judge names along the bottom, then a count of each type of run creating the bar chart…
| Judge Name | Clear | Faults | Eliminated |
|---|---|---|---|
| Jo Bloggs | 1 | 3 | 5 |
| Sandra Dee | 2 | 8 | 1 |
| John Doe | 5 | 1 | 9 |
My problem is, if I put a contraint on the search for runs by the run status (clear.faults,elimintaed etc) if there is zero runs for a judge in a category the list doesn’t match the list of judges.
Is there a way I can do this?