Hello, I’m new to Grafana; I’ve installed influxDB and Grafana on my Home Assistant.
I have a sensor measuring the power consumption in my house and an integration sensor that integrates W to calculate Wh.
I have setup an utility meter showing the total Wh and resetting every day at midnight.
I want to use Grafana to create a dashboard where I can easily switch from hourly to daily, weekly or monthly view
By default, Grafana plots a mean but I don’t think that’s what I want
I think what the query should do for each time interval is calculating the difference between the last and the first value in that time interval (as the source sensor only resets daily)