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

digitaldex February 23, 2020, 11:41am 10

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

2 Likes

Topic		Replies	Views
Average per hour influxdb	12	20510	September 10, 2025
[Newbie] Graph that converts watts/hr to watts Dashboards time-series , chronograf , flux	0	185	January 15, 2024
Return data for time of use billing estimation Dashboards influxdb , grafana , time	0	1291	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	756	September 12, 2022
Obtaining the average power consumed in the hour of greatest consumption InfluxDB 2	6	430	January 31, 2023