Create Pie Chart With SQL Query Question

I have a Question that I constructed using an SQL query. Something like this:

(SELECT COUNT() FROM MyTable WHERE Result='OK') AS Passed,
) FROM MyTable WHERE Result<>'OK') AS Failed

I'd like to make a simple pie chart with the Passed and Failed values, but can only seem to choose one or the other values as either the Dimension or Measure.

You need to group by result and just do a count since you are creating two columns instead of 2 rows

1 Like