Is there a way to create a panel with a heatmap where the x-axis is not absolute time, but buckets of weekdays, e.g. monday, tuesday, wednesday, etc, and y-axis is e.g. hour-of-day. Can be useful to detect periodic load patterns.
I’m using InfluxDB and can group by a custom parameter that I’ve put in my series, e.g. ‘hour’ or ‘weekday’, but I can’t find a way to present it as a 2D-heatmap, although the query results is a NxM data structure as expected.
Hello!
I don’t think this is possible with default Heatmap panel but you can use the Hourly heatmap plugin to achieve exactly that.
Thanks @agnestoulet1. That’s a pretty cool plugin and it works well and it’s very useful, though I don’t see a way to aggregate data into weekday buckets on the x-axis though (i.e. to show the average for each hour/weekday for the last year; essentially 168 buckets, but displayed by weekday on x-axis and hour on y-axis)
Bump 3 years later… Did you achieve the aggregated weekdays? I’m looking for exactly that too and can’t seem to find any way to get the desired result…
I would love to know also, I’m still looking for a solution to this. It’s one of the only things keeping us from swapping from excel to grafana.