Energy Dashboard cost/compensation calculation stopped working when I upgraded to 2021.9

[del13r]

Hi,

I noticed my cost calculation in Energy Dashboard stopped working as soon as I upgraded to 2021.9 as shown in the image below:

This feature was previously working fine in 2021.8.
I did some troubleshooting and found out why.
This is a post mortem of how the issue was caused and how I fixed the issue.

How the issue was caused:
When Energy dashboard launched in 2021.8, I had not yet changed my currency from the default EUR under Configuration / General / Currency.
My local currency is AUD.
When long term statistics was initialized in 2021.8, Home Assistant assigned the current currency value to Energy Dashboard which was EUR at the time.
Once I noticed the EUR symbol in Energy Dashboard, only then did I take steps to change the currency to AUD.
Changing the setting was easy enough and had an immediate impact on the currency smybol displayed in the Energy Dashboard.

Once 2021.9 came out, Energy Dashboard noticed that the EUR unit was not the same as my current currency of AUD and decided to stop recording costs all together.
I can understand why, because the units need to match in order for calculations to continue.

How I verified the issue:
Installed this

Home Assistant Community Add-on: SQLite Web

[hassio-addons] This add-on is provided by the Home Assistant Community Add-ons project. [GitHub Release] [GitLab CI] [Project Stage] [Project Maintenance] [Supports armhf Architecture] [Supports aarch64 Architecture] [Supports amd64 Architecture] [Supports i386 Architecture] Explore your Home Assistant database from your web browser! [image] About This enables you to easily explore all tables and content that is saved in your database. Insta…

How I installed it
Supervisor / Add-on Store / SQLite Web / Install / Run / Open Web UI

Once running, I did this:
statistics_meta / Query

SELECT *
FROM "statistics_meta" where unit_of_measurement = 'EUR'

These EUR units need to be changed to AUD so that Energy Dashboard resumes cost caculations.

How I fixed the issue:

update "statistics_meta" 
set unit_of_measurement = 'AUD'
where unit_of_measurement = 'EUR'

After that my energy dashboard started recording costs correctly again after 1.2 hours (1h 12m).

[del13r]

Seems this solution can also be used to fix NULL unit_of_measurement preventing integration energy sensors from being selected in energy dashboard.

See

Enphase Envoy with Energy Dashboard

Thank you for posting this! I used this to go update the sensor that I couldn’t see in the Energy config directly in the database to kWh. It showed correctly everywhere but in the database it was still NULL. As soon as I did that it showed up in Energy configuration. I had tried everything else and if I hadn’t seen your post I don’t think I would have ever gotten it fixed!

And

Enphase Envoy with Energy Dashboard

mine does, indeed show NULL under sensor.grid_import_energy [image]

[rob6 (Rob)]

Thanks for this post, I had exactly the issue you described and have been trying many things to resolve it, updating the entry as you described sorted it.

One addendum that I did was to remove all the stats generated to date on that stat ID, because it’s been nearly two months since this stopped working I suspect that the yearly cost stats would be completely wrong so may as well start again.

[del13r]

I just noticed a new feature in developer tools that shows any issues with the long term statistics database which is what energy dashboard uses

It even offers a “fix issue” button.

[ArminF (Armin Felkel)]

well… i went to the developer tool log and pressed FIX ISSUE.
errors are gone after restart of service.

Does the Energy calculation comes back? I assume it must gather new data to show movement on the board?

Please say am right
thank you!

[del13r]

Hard to say as it depends on exactly what issue the fix issues button fixes?
Did you take notice before pressing it?

In my picture example above, my issue was that I was excluding certain entities from the recorder. Pressing the fix issue in that case would not fix the energy dashboard for me

[greenfan (James Clough)]

Thanks for this post, I got into the same issue with the same steps. The Fix Issue button changed the historical EUR amounts to AUD; for me this made the cost of imports & exports since I switched to AUD suddenly show up as today’s costs, then accounting resumed successfully the next day.