Grafana problemas con visualizacion "Trend"

[sebastiannav]

Buenos días tengo hecho esta consulta mysql con tablas en GLPI.

SELECT
MONTH(date) AS month,
SUM(CASE WHEN YEAR(date) = 2018 THEN 1 ELSE 0 END) AS "2018",
SUM(CASE WHEN YEAR(date) = 2019 THEN 1 ELSE 0 END) AS "2019",
SUM(CASE WHEN YEAR(date) = 2020 THEN 1 ELSE 0 END) AS "2020",
SUM(CASE WHEN YEAR(date) = 2021 THEN 1 ELSE 0 END) AS "2021",
SUM(CASE WHEN YEAR(date) = 2022 THEN 1 ELSE 0 END) AS "2022",
SUM(CASE WHEN YEAR(date) = 2023 THEN 1 ELSE 0 END) AS "2023",
SUM(CASE WHEN YEAR(date) = 2024 THEN 1 ELSE 0 END) AS "2024"
FROM 
glpi_tickets
GROUP BY month
ORDER BY month;

Sin embargo al visualizar en el panel o en una lista de reproducción se ve de la siguiente forma:

En que me estoy equivocando?? gracias por su ayuda.

[yosiasz]

bien venidos @sebastiannav

En este foro utilizamos el inglés como medio de comunicación.

The data returned by your query has only 1s and 0s

[sebastiannav]

Hello, thank you for your help, in mysql I could not add the [ ], however it remained like this.

SELECT
MONTH(date) AS month,
SUM(CASE WHEN YEAR(date) = 2018 THEN 1 ELSE 0 END) AS "2018",
SUM(CASE WHEN YEAR(date) = 2019 THEN 1 ELSE 0 END) AS "2019",
SUM(CASE WHEN YEAR(date) = 2020 THEN 1 ELSE 0 END) AS "2020",
SUM(CASE WHEN YEAR(date) = 2021 THEN 1 ELSE 0 END) AS "2021",
SUM(CASE WHEN YEAR(date) = 2022 THEN 1 ELSE 0 END) AS "2022",
SUM(CASE WHEN YEAR(date) = 2023 THEN 1 ELSE 0 END) AS "2023",
SUM(CASE WHEN YEAR(date) = 2024 THEN 1 ELSE 0 END) AS "2024"
FROM 
glpi_tickets
GROUP BY month (date)
ORDER BY month (date);

Now on the visualization it looks like this…

[yosiasz]

@sebastiannav

in mysql I could not add the

What is that [ ], not sure I understand

[sebastiannav]

I don’t know how to solve it :c

[yosiasz]

disregard that, it was me testing your scenario on my sql server. but still not sure I understand your problem. I also do notice your data ranges are 1969