Hello everyone, I’m new to both the Community and Grafana. I hope you can help me
I’m using Grafana v9.5.3 (916d9793aa) in Windows 10 Home
I’m trying to make a heatmap
The origin of the data is PostgreSQL
This is the query i’m using:
SELECT
EXTRACT(HOUR FROM "FECHA") AS Hora,
TO_CHAR("FECHA", 'Month') AS Mes,
SUM("CANTIDAD") AS Cantidad
FROM
rampas_dia
WHERE
$__timeFilter("FECHA")
GROUP BY
EXTRACT(HOUR FROM "FECHA"),
TO_CHAR("FECHA", 'Month')
ORDER BY
Hora ASC,
Mes DESC
Also, I have a “Grouping to matrix” Transform in which
Column is mes
Row is hora
Cell value is cantidad
Empty value is True
This is the thing:
The Grafana shows the axis wrong.
This picture should shown the hours of the day Vs. the months of the year. But it shows only a few hours and overwrites values.
We can see in the pictures below that 9, 10 and 11 are before 8. And also that the cells overlap
Even the months are not ordered even though it is in the query.
Please, I really need your help!!! I have all day changing things and nothing works
Greetings,
Antonio