Is there a limit to year graphics? Topic is solved

[Kedi]

I have my Domoticz installed from 2015.
I wonder if there is a limit the the month 'Comparing Usage' graphics P1 smart meter widget.
Currently it fits nicely, but will Domoticz housekeeping keep all the years, and will the be displayed for ever, or is there a limit to it?

[Kedi]

Nobody with an answer?

[waltervl]

The one who implemented the compare chart is not on the forum, only on GitHub (michahagg). Looking at the code it does not seem to limit it.

[Kedi]

Tnx.

[gizmocuz]

Domoticz will never remove day values from the database.
Maybe we should limit the compare chart in the feature as you don't want to see 20 years in the chart

[BartSr]

I would leave deleting records to the users.

[waltervl]

Not showing is not the same as deleting.....

[Hansbit]

Is it possible to show an extra chart, for both P1 gas and electricity charts, just showing the total year usage per year?

When choosing a new energy supplier, for price comparison, I have to submit the gas and electricity on yearly basis. Now I have to add up all 12 month manually...

And it will also be nice to see if any energy saving measures take effect over years.

[HvdW]

What you can do.
Go Setup -> Settings -> Backup/Restore
Do a backup.
Note the IDX of Power and Gas
Install and open DB Browser (SQL)
Open your backup
Go tab Browse Data (Gegevensbrowser)
Scroll Table (starting with applications)
Choose Multimeter calendar
set filter to the idx of your P1
Choose the dates you nee like 01/01/2023 and 31/12/2023 and copy fields Counter1, Counter2, Counter3,Counter4, Date
Paste it in a spreadsheet and off you go.

Code: Select all

Dal gebruik	Dal terug	Piek gebruik	Piek terug
29907340	10779111	16001275	25861618	2023-07-05
27797678	9464948		14731310	23015900	2022-07-05
2109662		1314163		1269965		2845718	

Divide by 1000 and truncate to get kWh

Best option right now seems to be Vattenfall

PS Sorry for the amount of off topic here.

[waltervl]

Is it possible to show an extra chart, for both P1 gas and electricity charts, just showing the total year usage per year?

When choosing a new energy supplier, for price comparison, I have to submit the gas and electricity on yearly basis. Now I have to add up all 12 month manually...

And it will also be nice to see if any energy saving measures take effect over years.

Why in a chart? Just go to the P1 Electricity report page or the P1 Gas report page (device Log -> Report) and you see everyting per year.....
https://www.domoticz.com/wiki/Managing_ ... ice_Report

You can also set the compare chart (last chart) to year display and it will show the logged results per year (and not default by month).

Schermafbeelding 2024-06-14 001650.png (35.92 KiB) Viewed 1613 times

[gizmocuz]

If I look at my P1 graph, there is a limit of 10 years. I do not see data before that

[Hansbit]

...
You can also set the compare chart (last chart) to year display and it will show the logged results per year (and not default by month).
Schermafbeelding 2024-06-14 001650.png

Found it! Overlooked clicking on 'y' for years. Thanks!!