Energy graphs not showing meter history

[cure1245]

Checklist

• [X] I have updated to the latest available Home Assistant version.
• [X] I have cleared the cache of my browser.
• [X] I have tried a different browser to see if it is related to my browser.

Describe the issue you are experiencing

I am reading my energy meter's AMR signal using an SDR that reports to an MQTT broker. About a week ago, the bar graphs showing usage per time period are no longer appearing, although the graph scaling and amounts below the graph are accurate: Here's a picture of the raw meter sensor:

Describe the behavior you expected

I expect there to be bars showing on the graph.

Steps to reproduce the issue

1. Use MQTT to connect an energy meter entity

3. ...

What version of Home Assistant Core has the issue?

Home Assistant 2022.12.0.dev20221124

What was the last working version of Home Assistant Core?

No response

In which browser are you experiencing the issue with?

All broswers

Which operating system are you using to run this browser?

Any OS

State of relevant entities

No response

Problem-relevant frontend configuration

No response

Javascript errors shown in your browser console/inspector

No response

Additional information

No response

[ZsBT]

same here, 2022.12.0.dev20221119 in docker

[cure1245]

So I updated my docker container to 2023.1.0.dev20221202 about 24 hours before writing this, and within the last 15 minutes as of writing this the bars returned. I was looking at the energy dashboard, I went to the meter sensor history and set the history graph to a three hour window, and when I went back to the dashboard it was all there!

[ZsBT]

same here, 2022.12.0.dev20221119 in docker

I had to purge tables statistics and statistics_meta. After HA started to collect new sensor data, it appears again on the dashboard. I don't get what could cause incompatibility, but at least I have graphs again.

[cure1245]

Well, I guess since we were the only two people who mentioned having it and we're both good now I'll close the issue out.

[cure1245]

So I just updated to 2022.12.4 and the issue has returned...

[github-actions[bot]]

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.