Creating a grafana dashboard for daily energy consumption

Configuration
1

Hi,
i have some trouble generating a Grafana dashboard out of a utility meter sensor, exported by the prometheus integration and scraped. The utility meter sensor for getting the daily energy consumption is generating a sawtooth chart in Grafana, one sawtooth per day.
What i want to achieve is a pillar diagram, showing the max sawtooth value per day. What i cannot get on my own is what i need to configure in Grafana for that. All texts about similar topics reside on having the values categorized (by day) inside the data source. They are not in this case. I am also unsure what diagram type i need to chose. Bar chart? Bar gauge?

2

Untitled
Untitled1433Ă—275 18.9 KB

Choose a “Time Series” chart and set that graph style to “Bar”.

2 Likes
3

Thanks, this was helpful. There are two problems remaining: I am not using InfluxDB as a storage backend but Victoriametrics, so i need to write the Query in PromQL and not in Influx’s SQL dialect. So far i have max_over_time(hass_energy_wh{entity="sensor.energy"}[1d]) which produces the following output with a bar-styled time series chart:

Unbenannt
Unbenannt1413Ă—349 13.2 KB

The ultimate goal i want to achieve should look more like that: Daily power consumption from watts - #5 by lipovmar - InfluxDB - Grafana Labs Community Forums

I am still stuck somehow.

4

This was really helpful. I knew that I need MAX value of the day but was looking in the previous period - to have the max. With max you can keep looking to “value” field.

However, what I still find tricky is how to change the labels to “washing machine” “desk” “fridge” to have a comparison table similar to this one:

image
image3052Ă—787 102 KB

5

Change the ALIAS.