Hey! Ok I cant solve this problem. I have a sensor with increasing kWh. And and I did use group by 1 day but how do I make it show me the total increased per day? I want one bar per day showing me the total usage for that day. Is that possible? [123123]

Made an example dashboard [image] Daily consumption panel: [image] [image] [image] Total consumption panel: [image] Dashboard JSON Model { "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, …

The data is stored in UTC, but you can change the timezone by changing the TIMEZONE field. [image] (Europe/Oslo is my timezone). The timezone name is the “TZ database name” column from List of tz database time zones - Wikipedia

How do I do that? I dont think there is much to show though since I really haven’t got anything together! Isn’t there just a button to press to show the increased data per day? This must be quite a standard thing to have in everyone’s energy overview?

I mean I already have everything I want in Home Assistant’s own Energy Monitoring/Dashboard [123] . But that data is stored locally on HA. And I would like to have the same overview in Grafana. So not only daily usage but also hourly etc… I use the same sensor in Grafana as I do in HA’s own energ…

There is a bar option in Grafana as well. The graph is default lines, but can be changed to bars in the display options of the panel. [image] [image] To get the time at the bottom you have to set X axis to be Time in the Axis options of the panel. [image] Edit: There is also a bar chart in bet…

Thanks! I think I managed to get the bars working. But I only manage to get them to show the increasing numbers. All I want is each day’s bar to show that days consumption. How do I do that? [123]

export it from within influxdb [image] Please see this thread to see importance of providing sample data [image] Show string values in time series graph InfluxDB How does this look with Time Series? [image] python script used to parse your “csv” to reiterate the impo…

Hm not sure I follow you want my influx raw data? But so there is no button/setting here to simply “show daily summarized data” ? I guess I have to do some kind of template sensor for that then?

You could add a select field with difference. [image]

There! Awesome, thank you! Exactly what I was looking for. That “Difference” was the magical setting :stuck_out_tongue:

Oh I checked it in detail, and it seems to be one day off in its values pure visual. The daily consumption of 26th is shown in the 27th bar. Is there some way to get that right? Hm

Total daily energy use

Grafana Configuration

zuperzee April 27, 2022, 6:36pm 14

You could add a select field with difference.

Topic		Replies	Views
Wrong value in graph with bars	38	21761	January 13, 2021
Summary and representation of daily to calendar monthly values InfluxDB dashboard	40	2042	July 22, 2024
Dashboard Math Problems InfluxDB	19	1140	September 15, 2023
Daily consumption in kWh 1 bar per day Dashboards	4	2580	November 15, 2022
Calculate daily power/coast consumption InfluxDB	15	39007	February 25, 2021

Total daily energy use

Related topics