Page 1 of 1

How to read log data to calculate sum/average?

Posted: Sunday 02 February 2020 9:24
by renerene
I want to compare the periodic bill of my power supplier with my P1 gas and power log data in domoticz. For example "what was my gas usage between 1st july and 31december las year?"
After Google i found some scripts, but they are based on 'collecting' (future ) instead of 'reading' (history)

Can somebody help my build that dzvents script?

Also handy for stuff like compare monthly average temperature with same month last year, etc.

Re: How to read log data to calculate sum/average?

Posted: Sunday 02 February 2020 14:45
by waaren
renerene wrote: Sunday 02 February 2020 9:24 I want to compare the periodic bill of my power supplier with my P1 gas and power log data in domoticz. For example "what was my gas usage between 1st july and 31december las year?"
Also handy for stuff like compare monthly average temperature with same month last year, etc.
What more do you need what's not already in the reports on the log tab ?
2019 Power
2019 Power
report.png (212.72 KiB) Viewed 1315 times
2019 Temperature
2019 Temperature
reportt.png (200.46 KiB) Viewed 1315 times

Re: How to read log data to calculate sum/average?  [Solved]

Posted: Sunday 02 February 2020 23:37
by renerene
Thank you. I wasn't aware of this somewhat hidden report. Does the job, mission accomplished.