Hi, I am collecting the following data into influxdb from smartthings: power: current value in kW energy: cumulated value in kWh With a very simple request I can display the power consumption over time in grafana: SELECT mean("value") FROM "power" WHERE $timeFilter GROUP BY time($__interval), "…

Hi I have: SELECT non_negative_derivative(last("value"), 1d) FROM "device_119_usage" WHERE $timeFilter GROUP BY time(1d) fill(linear) where device_119_usage is momentary power usage Also time range I set to 1M. So I get daily usage in kWh in separate bars for every day.

Thanks @xury but this is not what I am looking for, at least I don’t think so. What I am looking is 1 graph over one 24h period that gives me my average consummation hour per hour for the selected period. for example, for a selected period of last 7 days, I want that graph to show me 24 points on …

Still cannot figure this out. Is this even possible ? My request should return me 24 lines: average of power consumption between 0am to 1am between day A and day B average of power consumption between 1am to 2am between day A and day B average of power consumption between 2am to 3am between day A…

[image] cben0ist: What I am looking is 1 graph over one 24h period that gives me my average consummation hour per hour for the selected period. for example, for a selected period of last 7 days, I want that graph to show me 24 points on the x-axis: Hi @cben0ist Is this of any help? SELECT …

Hi @cben0ist , Did you have success during the last year? I am trying to achieve the same and could not find any sources for it here or via Google. Regards Alex

No, but let me know if you find a way to do it please.

Maybe this could help. It is the visualization for my smartmeter with histograms per day and month [image] GitHub - digitaldex/piMeter_grafana: Software for piMeter EnergyMonitor Software for piMeter EnergyMonitor. Contribute to digitaldex/piMeter_grafana development by creating an acco…

Hi @digitaldex , I can’t test the visualization in Grafana right now, but had a look at the query: |"query": "today = from(bucket: \"piMeter\") |> range(start: -31d) |> filter(fn: (r) => r._measurement == \"downsampled_energy\" and r._field == \"sum_Gesamt\") |> aggregateWindow(\n every: 24h,\n fn:…

Hey, you only need to enable fluxlang in your influxdb installation and add flux datasource to grafana

Daily power consumption profile graph

InfluxDB 2 Dashboards

furmek July 11, 2023, 10:58am 11

It has been a while but someone was able to get it working here: Average per hour - #14 by MarioG

Topic		Replies	Views
Average per hour influxdb	12	20673	September 10, 2025
[Newbie] Graph that converts watts/hr to watts Dashboards time-series , chronograf , flux	0	197	January 15, 2024
Return data for time of use billing estimation Dashboards influxdb , grafana , time	0	1297	October 9, 2017
Calculation of the average energy consumption during the night hours from 10 p.m. to 6 a.m Fluxlang influxdb , query , flux	3	769	September 12, 2022
Obtaining the average power consumed in the hour of greatest consumption InfluxDB 2	6	465	January 31, 2023

Daily power consumption profile graph

Related topics