I have problems to plot heatmaps from grafana, I cannot understand how to make data source from MySQL, I have the next MySQL Query:
day(tiempo_arribo) AS “date”,
hour(tiempo_arribo) AS “hour”,
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)