search

home-assistant / core

:house_with_garden: Open source home automation that puts local control and privacy first.
https://www.home-assistant.io
Apache License 2.0
69.73k stars 28.88k forks source link

Persisting issue with handling DST in database / frontend visualization #114664

Open Kratax opened 3 months ago

Kratax commented 3 months ago

The problem

Just an update from this DST change - the issue is persisting... btw not related to one integration but seems to be general issue how database is solving DST... see couple of charts showing that... ie CO2 sensor, temperature sensor, and energy sensor

obrazek obrazek obrazek

https://github.com/home-assistant/frontend/issues/16058#issuecomment-2032801009

What version of Home Assistant Core has the issue?

core-2024.3.3

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

database storage - handling of DST time

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

chart_type: line
period: day
days_to_show: 14
type: statistics-graph
entities:
  - entity: sensor.netatmo_kalabisova_praha_obyvaci_pokoj_strecha_temperature
    name: Venkovní teplota
stat_types:
  - mean
  - min
  - max
  - sum

Anything in the logs that might be useful for us?

any statistics graph is not shown correctly, issue with energy dashboard in the period when DST happens...

Additional information

No response

issue-triage-workflows[bot] commented 2 days ago

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.