Remove 1 value from the gas meter database

[zanco]

Hi,
In my smart meter data the graph from last year shows one high peak and no other values. In the month April it looks like the meter total value (6910 m3) is taken instead of the daily consumption. So with an average use of 10 m3 a day the graph from the year will never show the right value.

Is it possible to locate this value and replace it with a more normal value ?

Thanks,

Ben

[SweetPants]

Is it possible to locate this value and replace it with a more normal value ?

Did you try pointing your mouse at the high peak and type "shift"+left-mouseclick? This allows you to remove this sample.
Other option is to use an sqlite3 database tool to edit the domoticz.db database.

[zanco]

Hi,

That worked great ! Removed two values and all is OK now


Big THANKS !

Ben

[zanco]

Hi, me again

Today I got another new smart meter, with wireless gas meter connected.

Somehow I now have a large (understatement...) negative gas use shown in the last week, but not on today's date. I can not shift left click on the weekly value to remove it (just tried).

Is there another way to do this or is this the time to find myself a dbase editor ?

negative_gas.png (117.16 KiB) Viewed 1742 times

Thanks,


Ben

[EddyG]

It should be possible to delete the value on the week graph on the normal way.
I also do it sometimes. You have to be precise where you left click.

[zanco]

HI, thanks for you reply.

Tried, tried again, switched to Firefox, tried, tried again, repeatedly get the question "do you want to delete.." and answered yes, with no luck getting the value removed.

This morning I tried again, and I could remove the high values without problems. Might make sense to wait till the day has finished before trying to remove a value ?


Thanks,

Ben

[EddyG]

Of course, the daily data is still there in the graph from above.

[PieterS]

The method of deleting a value out of a graph is known and working for me in a line-graph. But that method of shift+left mouseclick does not seem to work for a bar graph. The question is asked to remove the value and confirm your choice. But after that the bar (and) database are not changed...

I tried in Firefox and Chrome. But no luck up till now. See footer for my versions..

Strange fact: When I use this trick in graphs of usage last 24 hours, last week, last month it goes wrong. When I use graph of last year and I zoom in and select that day it works as expected... Only problem is that the total value did not change..

Any suggestions to get this working?