Difference domoticz dashboard and .db file

[jjeroen]

Hi Guys,

I've installed demoticz for a few hours now and I'm very happy! Stats are getting in. To see if I could build up advanced stats from the DB itself, I've read the .db file and exported it to excel. Here I find some differences in the data, that I can't understand. Can you help me out?

In the visual graphs from Domoticz I see a peek at 12:55. While in the Excel data, that peek is not there. Both the domoticz dashboard and the excel only read idX5. The second row is idX6, and that's my lower rate power (only for night situations). The data is coming from a "slimme meter" (smart meter), connected with an usb cable to my raspberry pi.

Why is the result different in excel from in the dashboard? And which one is right? See 2 attachements for screenshots from the dashboard and from exel.

Dashboard:

Schermafbeelding 2019-06-29 om 15.38.01.png (283.64 KiB) Viewed 395 times

Excel result:

Schermafbeelding 2019-06-29 om 15.46.40.png (226.82 KiB) Viewed 395 times

[szakaria]

It seems to me that domoticz is plotting graphs using some kind of smoothing (maybe exponential smoothing).