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)
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
Energy graphs error Topic is solved
Moderators: leecollings, remb0
Forum rules
Before posting here, make sure you are on the latest Beta or Stable version.
If you have problems related to the web gui, clear your browser cache + appcache first.
Use the following template when posting here:
Version: xxxx
Platform: xxxx
Plugin/Hardware: xxxx
Description:
.....
If you are having problems with scripts/blockly, always post the script (in a spoiler or code tag) or screenshots of your blockly
If you are replying, please do not quote images/code from the first post
Please mark your topic as Solved when the problem is solved.
Before posting here, make sure you are on the latest Beta or Stable version.
If you have problems related to the web gui, clear your browser cache + appcache first.
Use the following template when posting here:
Version: xxxx
Platform: xxxx
Plugin/Hardware: xxxx
Description:
.....
If you are having problems with scripts/blockly, always post the script (in a spoiler or code tag) or screenshots of your blockly
If you are replying, please do not quote images/code from the first post
Please mark your topic as Solved when the problem is solved.
-
- Posts: 69
- Joined: Sunday 08 June 2014 20:31
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Location: Toulouse France
- Contact:
Energy graphs error
domoticz on Raspberry Pi + RFXcom LAN moded + wifi
Blyss / DI.O / homemade / ESP / wemos
Blyss / DI.O / homemade / ESP / wemos
- jvdz
- Posts: 2189
- Joined: Tuesday 30 December 2014 19:25
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 4.107
- Location: Netherlands
- Contact:
Re: Energy graphs error
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.
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.
New Garbage collection scripts: https://github.com/jvanderzande/GarbageCalendar
-
- Posts: 69
- Joined: Sunday 08 June 2014 20:31
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Location: Toulouse France
- Contact:
Re: Energy graphs error
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 !
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 !
domoticz on Raspberry Pi + RFXcom LAN moded + wifi
Blyss / DI.O / homemade / ESP / wemos
Blyss / DI.O / homemade / ESP / wemos
Who is online
Users browsing this forum: No registered users and 1 guest