Meter readings to hourly usage bar chart

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    9.3.1 (docker.io/grafana/grafana:9.3.1), data source is Graphite, fed through StatsD.

  • What are you trying to achieve?
    Turning a continuous stream of smart meter readings (total consumption, monotonic gauge) into a bar graph (or line graph) with hourly consumption.

  • How are you trying to achieve it?
    Create a graph, based on a metric (say stats.gauges.smarthome.utilities-power-high) and then I get stuck, because I’m trying to find a function to aggregate a delta per time window (an hour, a day, whatever makes sense for the current timeframe).

I’m convinced what I’m trying to do should be possible, right? It feels like a fairly common usecase, but maybe I’m mistaken.

Any help would be appreciated, thanks in advance!