rkasinski

Hello,

how to use this coloring in donut chart if I get data from SQL Database by below code;

SELECT
status,
ROUND((COUNT()/480100),0) AS ilosc
FROM
winding_v_1st
WHERE
DATE(DATETIME) = {select_date}
AND
TIME(DATETIME) >= “06:00:00” AND TIME(DATETIME) <= “14:00:00”
GROUP BY status;

I confirm it works

Thank You.

Issue was in SQL string.

Hi, I think I have found solution, I change SQL query. Previus generates 9,19,20,16,17,18 – looks that You don’t see attahced picture.

No i load Query like below, and I tested.

SELECT
HOUR(datetime) AS godzina,
SUM(CASE WHEN status LIKE ‘%ONLINE%’ THEN 1 ELSE 0 END) AS total
FROM winding_h_6m
WHERE
HOUR(datetime) BETWEEN 6 AND 23 AND datetime LIKE CONCAT(LEFT(‘2025-0-06,10’),”%”)

GROUP BY
HOUR(datetime)
ORDER BY
godzina;

When I run separately the query in MyAdmin, then is working fine. But when I generate charts the resuls is like I attached.