it seems to me I’m too dump to understand integral() function in influxQL.
I’m trying to get my self made heat counter for my heat pump system. In influx I have data about current heat power output in Watts sampled in ~5sec. Which works great so far. But I’m absolutely unable to get an accurate cumulation or summation on a daily base.
IMHO integrating the available samples should be the way to go. But the result of Integral() is always insanely wrong. e.g. 2-3MWh produced in 24h on a warm spring day from a 10kW heat pump.
Is there anyone who could help me to get rid of that?
Attached you will find a sample.csv with date where my heat pump was running for about 34min with a mean output of 4kW, which should resulting around 2,1-2,2 kWh.