Measure the area under a line graph in grafana - same in openhab rule

Setup, Configuration and Use Scripts & Rules
#1

Hello,
Im having Power consumption data form my HeatPump given in Watts.
In grafana I can calculate How many kWh it takes in timeseries.

SELECT integral("value") /3600000 FROM "pompa_dane_suma_energii" WHERE $timeFilter
where time is now/d. (since start of the day)

This thing calculates field under a line graph.

How to do this in openhab rule?? So that I will have this kWh since start of the day in openhab?

#2

How are you persisting your data? You can probably exploit that.

#3

Im using influxdb.

I don’t know how to write rule with integral?

#4

Well, let’s say you are persisting data every hour. You can sum the records since last midnight.

#5

But I need to calculate integral, not sum.

#6

The integral basically is a sum, at least in approximation. But given that the x-axis is time and it does not have the same meaning as the y-axis I’m not entirely certain what the integral will tell you. You’ll get fairly different different results depending on how you interpret the x-axis and convert it to a number that you can then use to calculate the area between two points using the trapeziodal rule or Simpson’s rule or what ever approach you choose.

I do notice that InfluxDB has an integral function built in which you could call out to using executeCommandLine. It might be worth a look to see how it interprets the time axis to do it’s calculation.

#7

You said you wanted the kWh, not some particular method.

A simple approximation is to persist kW everyMinute and then sum / 60 = kWh