Reports over several Utility Sensors

[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

[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.

[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

[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.

[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.