Recalculate energy cost | Home Assistant | Page 1

honest siren Oct 17, 2025, 8:39 PM

#

Hey everyone! Is there a way to reset the price counter calculated by the energy dashboard? I had a sensor showing the current electricity price in cents, but the energy dashboard expects a sensor showing EUR/kWh. Now the cost is 100x too high for the past few days 😄

Is there a way to recalculate?

reef solar Oct 17, 2025, 8:45 PM

#

Not really. You can wipe and start over starting from now, or you have to manage your database directly.

#

If you're really comfortable with sqlite you could probably figure out how to edit it.

honest siren Oct 17, 2025, 8:49 PM

#

Thanks! I am already browsing the sqlite database using the addon. But I cannot find the data there. Where does the energy dashboard store the data?

reef solar Oct 17, 2025, 8:51 PM

#

Statistics table

honest siren Oct 17, 2025, 8:51 PM

#

I found the way to fix sensor readings, but not the price.

#

https://community.home-assistant.io/t/correcting-energy-states-in-home-assistant-with-sql/651966

Home Assistant Community

Correcting Energy States in Home Assistant with SQL

Yesterday it snowed all day, and my photovoltaic panels were completely covered with snow. Nevertheless, Home Assistant showed a PV yield of 4kwh around 07:30. After some hours of troubleshooting I was able to find the error this morning. For whatever reason, my power meter had reset the info interface to the default, which no longer provides th...

reef solar Oct 17, 2025, 8:52 PM

#

If you use a price entity HA creates a _cost entity for you, named similarly to its consumption entity.

#

You'll find that in the statistics table

honest siren Oct 17, 2025, 8:52 PM

#

lemme check it out immediately

#

so I get the info from statistics_meta

#

there I found tasmotafridge_energy_today_cost

#

ok, done, thanks

#Recalculate energy cost