Getting a listof items for stacked chart

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?