Heatmap with wrong axis

Hello everyone, I’m new to both the Community and Grafana. I hope you can help me :slight_smile:

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 :frowning:

Greetings,

Antonio

1 Like