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

Easy to use, 100% Lua-based event scripting framework.

Moderator: leecollings

Post Reply
renerene
Posts: 356
Joined: Wednesday 03 August 2016 11:36
Target OS: -
Domoticz version:
Contact:

How to read log data to calculate sum/average?

Post 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.
User avatar
waaren
Posts: 6028
Joined: Tuesday 03 January 2017 14:18
Target OS: Linux
Domoticz version: Beta
Location: Netherlands
Contact:

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

Post 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 1314 times
2019 Temperature
2019 Temperature
reportt.png (200.46 KiB) Viewed 1314 times
Debian buster, bullseye on RPI-4, Intel NUC.
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
renerene
Posts: 356
Joined: Wednesday 03 August 2016 11:36
Target OS: -
Domoticz version:
Contact:

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

Post by renerene »

Thank you. I wasn't aware of this somewhat hidden report. Does the job, mission accomplished.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest