Page 1 of 1

Energy graphs error

Posted: Wednesday 13 November 2024 16:40
by sebitop
Dear all

I'm experiencing an issue with my electric counter graph.
I have a module getting live electricity usage from my counter and I retrieve these values in domoticz
Time to time it gets wrong values (ie really high ones) that I correct in the database.

Meanwhile even after corrections I still see a huge value in November (see my graph below in blue)
2024-11-13.jpg
2024-11-13.jpg (128.73 KiB) Viewed 1139 times


As I don't know the way it is computed could someone help me finding a way to correct this one in november?
there is no way to delete the value on the graph so I assume it's computed

thanks for your precious help
Kind regards
Sébastien

Re: Energy graphs error

Posted: Wednesday 13 November 2024 16:45
by jvdz
How have you done the correction, as that could be the result of duplicated records in the Multimeter_Calendar table for this device?
Just open a copy of the current domoticz.db and open that with "SQLite Expert Personal" so you can check the table for this device.

Re: Energy graphs error

Posted: Wednesday 13 November 2024 20:54
by sebitop
Thanks JVDZ

there was no duplicate

after a deep dive I found that there are 2 columns in the METER_CALENDAR table named VALUE and COUNTER

VALUE is the total consumption per day
COUNTER is the sum of the previous total + the current day

so I correctly modified the values but not the total counter hence the residual million watts computed
to correct it properly the last correct sum value must be taken and then I did a proper sum after each day on excel

saved the DB and reinjected it into domoticz
it works well !

solved now
thanks for helping !