Sum energy values stored in influxdb

@ThomDietrich does a query like this calculate the Power?

InfluxDB has Integral but grafana somehow only let us use the default value 1s.
So i just integrate the value for 1s and cumulative_sum them after that devide it by 3600 to get hours.
The time interval has also to be set to 1s.

In the math field also the price calculation could be added.
Unfortunatly the starting point of the sumation is always the left border.

Or maybe an implementation with continues queries?

powerConsumption

2 Likes