Mysql pie chart "Operand should contain 1 column(s)"

1

Hello,

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 !

2

I founded the solution.

3

Can you post it for other people?

4

Yep, the solution is here :
I have to use a UNIX_TIMESTAMP and for each SUM I have to use “+”.
in my database I have three columns with 1, 2 and 3, and I want to know the total number of 1 in each column.
So the good query is :

SELECT UNIX_TIMESTAMP(NOW()) as time_sec,
SUM(CASE WHEN number1 = 1 THEN 1 ELSE 0 END) + SUM(CASE WHEN number2 = 1 THEN 1 ELSE 0 END) + SUM(CASE WHEN number3 = 1 THEN 1 ELSE 0 END) as ‘DELIVERY’,
SUM(CASE WHEN number1 = 2 THEN 1 ELSE 0 END) + SUM(CASE WHEN number2 = 2 THEN 1 ELSE 0 END) + SUM(CASE WHEN number3 = 2 THEN 1 ELSE 0 END) as ‘GOOD’,
SUM(CASE WHEN number1 = 3 THEN 1 ELSE 0 END) + SUM(CASE WHEN number2 = 3 THEN 1 ELSE 0 END) + SUM(CASE WHEN number3 = 3 THEN 1 ELSE 0 END) as ‘FAILED’
FROM artefact ;