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

Is it possible to get hourly averages over a period of time with Flux?

Topic		Replies	Views
Trying to get an average over n days and I must be doing it wrong	4	8827	August 14, 2018
Energy usage one day grafana	1	1687	October 23, 2018
[Newbie] Graph that converts watts/hr to watts Dashboards time-series , chronograf , flux	0	179	January 15, 2024
Get kWh from continous W values over given time period InfluxDB 1 grafana	0	567	October 28, 2022
Consumption monitoring Grafana influxql	7	1262	June 2, 2021