Page 1 of 1
Energy/Gas - More detailed view for previous days
Posted: Tuesday 30 May 2017 11:56
by wlevels
Hi all,
Is there a way to see a more detailed view of energy/gas usage for earlier days?
When analysing my energy/gas usage it would be nice to see if the energy usage is higher then normal for like yesterday, that I could zoom in and see during what time there was high energy usage?
I can only see the detailed view for today, so I would need to make a screenshot at the end of every day if I want to look back?
Thanks!
Wesley
Re: Energy/Gas - More detailed view for previous days
Posted: Tuesday 30 May 2017 12:03
by Egregius
That's handled by the 'Short Log Sensors' setting (1-7 days).
If you wan't to keep it longer you'll need to put up a system to store in another database.
Keep in mind that your database size will grow if you change that setting.
Re: Energy/Gas - More detailed view for previous days
Posted: Tuesday 30 May 2017 13:46
by wlevels
Egregius wrote:That's handled by the 'Short Log Sensors' setting (1-7 days).
If you wan't to keep it longer you'll need to put up a system to store in another database.
Keep in mind that your database size will grow if you change that setting.
Thanks for your reply!
Still running Domoticz on a RPI I had lying around to first testdrive it, let's see if it can handle the extra database size on the Raspberry until I eventually will upgrade to some better hardware

Re: Energy/Gas - More detailed view for previous days
Posted: Tuesday 30 May 2017 13:50
by Egregius
You could also try influxdb, there are already several members who use that to store their data.
I use the MySQL server of my webserver to store temperature and some other data that I want to keep and do my own analysis on.
Re: Energy/Gas - More detailed view for previous days
Posted: Tuesday 30 May 2017 19:37
by Amsterdam020
I use a python script and a mysql database running on the same pi as domoticz
See
viewtopic.php?f=65&t=16827
Re: Energy/Gas - More detailed view for previous days
Posted: Wednesday 31 May 2017 15:57
by wlevels
Thanks all for your input!
For now I changed the short log to 7 days, and I'm checking the possibility to use any database. I only have Domoticz running on a raspberry and I don't want to further burden it. I have a Synology NAS that should be able to run a Database using one of the available Apps for it, but maybe it's best to upgrade my Domoticz controller hardware so it can also handle an additional Database and the resource limits for expanding the environment are gone
