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), "…

Daily power consumption profile graph

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
Trying to get an average over n days and I must be doing it wrong	4	8463	August 14, 2018
Energy usage one day grafana	1	1625	October 23, 2018
[Newbie] Graph that converts watts/hr to watts Dashboards time-series , chronograf , flux	0	98	January 15, 2024
Get kWh from continous W values over given time period InfluxDB 1 grafana	0	451	October 28, 2022
Consumption monitoring Grafana influxql	7	1121	June 2, 2021