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), "deviceName" fill(previous)
What I am looking for now is to build a request that will profile my power consumption over a day, averaging each minute of the day over a period of time.
So that graph would only display 1 day from 0 to 24h and draw a line that would be my average consumption per (1|10|30?) minute(s) increments over the selected period.
This looks like a simple concept to me but I am not sure how to explain it, that’s maybe why I wasn’t able to find that answer yet
Let me know what you think about that, any help is appreciated.