Difference domoticz dashboard and .db file
Posted: Saturday 29 June 2019 15:46
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:
Excel result:
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 406 times
- Schermafbeelding 2019-06-29 om 15.46.40.png (226.82 KiB) Viewed 406 times