Create Pie Chart With SQL Query Question

Get Help
1

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

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

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.

2

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

1 Like