How to edit database

[Docc]

Hi
I am measuring power on an outlet with a Greenwave zwave plug and had a couple of power outages this Tuesday which seems to have corrupted the data. How can I edit this and remove the false values?
The 7 day graph is correct but the Last week graph is obviously wrong

2016-10-27_1012.png (95.18 KiB) Viewed 5685 times

[StanHD]

Hi, try holding Shift and Left Mouse Click on the point you wish to remove.

Edit:- Oops sorry, just tried that on my power graph (Week) and it doesn't work.

[borgkitty]

you could try what these guys are suggesting here
viewtopic.php?t=4128

I haven't done it myself but even before I found this I was goung to say something along the lines of phpadmin

[Docc]

Shift and Left Mouse Click worked, but only for the whole day in the month graph.

[Yustmenl]

I have done this and this works.

But because of the previous high values the total amount of energy greated by my solar pannels is still to high.
is there a way to recalculate this?

I already tryed to restart Domoticz but without the desired result.

Any ideas on how to do this?

[Egregius]

Use a sql3lite explorer/editor to change the value.