Calculate avg over time

---

Hello,
maybe that’s a easy one, but i don’t get it.
I want to calc an avg of an sensor input (e.g. Temp) over time (e.g. 24h).

So something like:
If (t < 24h)
{
tempSum = tempSum + tempcurrent;
i++
}

avgTemp = tempSum / i;

Has someone an idea how to do this?

This variable should be send over E-mail, which is not a problem email plugin works fine

Thanks
Free

@free118 I think you need to gather the measurement samples recorded during the day and divide by the number of samples which can be done by, e.g. writing a shell script which queries and aggregates the sensor data from pimatic. If the script provide the result output or it writes a result variable you can use as part of rule to shedule the mail reporting of the result.

@free118 If you are using a shell script anyway, maybe you can query the sqlite database directly. Something like SELECT AVG(column) FROM table WHERE timestamp BETWEEN NOW() AND NOW-24hours. Something like that. Haven’t looked in the db so far, but I think it is more easy than to collect every single data sample in some extra task.

Thanks for your answers.
I didn’t use the shell script plugin right know.
The post above was just rough pseudo c code.
It get it working with some combinded rules.

Thanks