How to plot a heatmap event count (day, hour) from timestamps?

Hello!

I have problems to plot heatmaps from grafana, I cannot understand how to make data source from MySQL, I have the next MySQL Query:

SELECT
day(tiempo_arribo) AS “date”,
hour(tiempo_arribo) AS “hour”,
count(*)
FROM PersonaEnCaja
WHERE
tiempo_arribo BETWEEN FROM_UNIXTIME(1568559600) AND FROM_UNIXTIME(1573916398)
GROUP BY 1,2

This results on a data that I need to plot, where the X axis has information about day and Y axis has information about hour, and the third column (count) has the quantity of interactions by each combination.

How can I translate this columns to a “heatmap” (I have tried a lot of things and I receive errors from grafana)

Thanks!

1 Like

@diegopdurante Did you figure this out? I’m also looking to do that same thing