Page 1 of 1

Reports over several Utility Sensors

Posted: Wednesday 18 August 2021 13:20
by arjenw
Hello members,

Is there any experience with combined reports?

I am looking for a combination of:
- 'Smart meter' Delivery and Usage over L1, L2 and L3
- SolarEdge kWh (generated power by Solar panels)
and if possible other devices which can tell me the generated Solar Power.

The layout of the reports can be the same as the current 'Smart meter' report.

Is there any example or experience with this type of reporting?

Thanks for your help and understanding in advance.
Best regards
Arjen

Re: Reports over several Utility Sensors

Posted: Wednesday 18 August 2021 13:30
by EddyG
Export your data to influxdb and report with grafana
https://www.domoticz.com/wiki/Influxdb and https://www.domoticz.com/wiki/HttpLink
You have to invest sometime to get some nice results.

Re: Reports over several Utility Sensors

Posted: Wednesday 18 August 2021 14:38
by waltervl
If you have a little bit SQL knowledge you can also make use of Grafana plugin for SQLite (Domoticz database) to combine all kinds of data in a graph.

https://domoticz.com/forum/viewtopic.php?f=21&t=35101

Re: Reports over several Utility Sensors

Posted: Wednesday 18 August 2021 15:00
by arjenw
Dear members,

Thanks you for the suggestions towards Grafana.

Will take a look at this on a separate RPi to collect the data and create the graphics.

Thanks.

Re: Reports over several Utility Sensors

Posted: Friday 20 August 2021 9:40
by EddyG
The possibilities of using Influxdb -> Grafana is a little bit bigger towards the future.
The problem is that Domoticz is not keeping all historical data, but makes daily and monthly averages or totals from current data.
With Influxdb you can keep ALL data if you wish.
I have setup both Influxdb and Grafana as Docker containers on my Synology NAS.