Creating a Day/Hour heatmap in Grafana

Question

What would be the best way to create a heatmap similar to this example where the counts are bucketed into time hour and day buckets?

Using the built in heatmap as well as the cal-heatmap plugin, it's only possible to create heatmaps over a period of time whereas I would like to aggregate into just the day of the week(monday, tuesday etc.) and the hour of the day.

Answer 1

The Carpet Plot plugin sounds like it fits this use case: https://grafana.com/plugins/petrslavotinek-carpetplot-panel

Here is a simple example:

Answer 2

For future-people that stumble across this (like myself)

Unfortunately, the Carpet plot plugin has not received updates in 3.5 years, so is no longer maintained. To add to that, Grafana has a new plugins platform based on React, instead of Angular, so I'm not entirely sure if some simple package updates would work on the old carpet plugin. I've tried running it on a new Grafana installation (7+), and it doesn't seem to work out of the box.

There is, however, a community plugin called Hourly Heatmap for Grafana, and it seems to scratch the same itch. More context is provided in their blogpost Plugin showcase: The hourly heatmap panel, built on Grafana's new plugin platform.