OpenEMS / openems

OpenEMS - Open Source Energy Management System
GNU Affero General Public License v3.0
764 stars 377 forks source link

Historical data not correctly displayed when changing device time zone #2360

Closed flsc42 closed 11 months ago

flsc42 commented 1 year ago
- [x] bug report -> please search issues before submitting
- [ ] feature request

I recently opened the history view from a device that was set to a time zone more to the West (e.g. Portugal time zone, -1 hour compared to my EMS time zone). The historical data of yesterday showed correctly in the graph, but not in the numbers below, instead it showed all "0" (see screenshot).

image

Interesting aspects:

Expected behaviour:

lukasrgr commented 11 months ago

hi,

do you save the data in the database in UTC time?

sfeilmeier commented 11 months ago

@flsc42 Thanks for reporting. It's maybe not an issue, but a misunderstanding in the expected behaviour. Because of this I would recommend closing the issue here and continuing the discussion on OpenEMS Community -> https://community.openems.io/

Expected behaviour: all data and events should be displayed in EMS time, no matter where on the world you view it.

In fact the system is designed to store all data in timezone UTC (that's what @lukasrgr was referring to) and visualize it according to the timezone of the viewer - not the EMS timezone.

flsc42 commented 11 months ago

It's up to you to close this and/or discuss the expected time zone elsewhere.

But showing "0" (as in my screenshot) is a bug, no matter what the expected time zone is.

sfeilmeier commented 11 months ago

Ok, agree, but this has most likely other reasons. It might be caused by the storage of aggregated timeseries values.

I just realize, that this looks like a FEMS and not OpenEMS screenshot. Is this a issue with FEMS? Then please send a ticket to FENECON Service team -> https://fenecon.de/kontakt/. Thank you.