I have some mini graph cards that show a daily bar graph of a sensor. The daily totals get reset to zero every night at about 12:03 AM.
I’m seeing that since we switched back to Pacific Standard Time this past Saturday, now most of the previous days on the bar graph (before the change) are showing zero or close to zero.
In the database times are stored in UTC, so before the time change something at 12:03 AM local time would be recorded as <DATE> 07:03:00. As far as the graph card is concerned, the day finishes at midnight which was <DATE> 07:00:00 so it would get the last value of the sensor. But midnight is now <DATE> 08:00:00 after the time change. When the card is pulling the history from the database, it’s now pulling all the records for 08:00:00 which at that timestamp, the sensor is usually still zero for the records before the time change.
So my graph is totally messed up now. What can I do to fix this? I’ve rebooted HA, and cleared the cached entity values from the browser.