I have a problem with my Query :
SELECT (SELECT UTC_DATE() AS time, SUM(res1+res2+res3) AS A from (SELECT SUM(CASE WHEN number1 = 1 THEN 1 ELSE 0 END) AS res1,SUM(CASE WHEN number2 = 1 THEN 1 ELSE 0 END) AS res2, SUM(CASE WHEN number3 = 1 THEN 1 ELSE 0 END) AS res3 from artefact) AS RES)
I want to use the pie chart panel.
I have the message “Operand should contain 1 column(s)” and I’m stuck I don’t know what to do anymore.
Can you help me?
Thank you very much !