I’m a newbie of influxdb, and start to test influxDB with Grafana (latest version of both).
I’ve a data series of instant DC power (Watt) that flow in a rechargeable battery.
The power has positive value when battery discharge and negative value when battery charge.
I want to calculate the energy (Watt hour) for charge and discharge phase.
For do this, I’ve used the integral function using clause WHERE, and create these 2 queries in Grafana:
_cumulative_sum(integral(“value”)) / 3600 FROM “Battery_Power” WHERE (“value” > 1 ) AND $timeFilter GROUP BY time($_interval)
_SELECT cumulative_sum(integral(“value”)) / 3600 FROM " Battery_Power " WHERE (“value” < 1) AND $timeFilter GROUP BY time($_interval)
Often the query work fine, and show a chart as I expected, other times, on chart I not see a data of integral, but the value seem have an offset.
Someone has same issue, or I’ve completely wrong my query syntax?