2022.4 - Energy Dashboard Recalculate After Adjusting Long-Term Statistics - (WAS Best Way To Edit Energy Dashboard Data? Remove or Edit Bogus Data on One Day from Tesla Powerwall)

[ziptbm]

What’s the best way to remove or edit data from the energy dashboard?

I set up my dashboard with active sensors feeding it data about 2 months ago and for some unknown reason, I got a bunch of bogus data on February 23rd (e.g. my home used 2,045 kWh of power and my solar generated 486 kWh).

It’s messing up any of the aggregate views and historical data, so I’d ideally like to edit the records to something more accurate, but would settle for simply deleting it out. I would assume this would involve some queries to the database (using MariaDB), but I am a completely n00b on SQL, so want to make sure I’m heading in the right direction and get any pointers before messing up my system. Any pointers or suggestions?

[tom_l]

How to fix statistics data (e.g. energy data)

Hey I have managed (I think) to solve the issue which was bothering me for a long time and I have decided to share the solution with you guys. I hope that someone finds it helpful. Problem I have OWL energy sensor which sends the data via RF433. The problem is that sometimes the received values are not correct. Pretty often I get “0” as the energy_total and once the value jumped significantly by 78M. [image] I don’t have the sensor data to investigate what has happened that day and what wer…

[tom_l]

An even easier way will be available in 2022.4

[ziptbm]

That’s great to hear!

I’m actually using MariaDB, but am trying to figure out how to fix this from the guide that is using MySQL. I’m not familiar with either db tech, so I’m trying to learn quickly…haven’t gotten far yet.

[ziptbm]

2022.4 made it super simple to edit the rouge data points for the sensors, so it’s reflected correctly in the source data.

However, the Energy Consumed data at the top of the Energy Dashboard still reflects the ridiculous spiked data. Does anyone know how to have it recalculate that part? I made the changes yesterday, so it’s been more than 2 hours since that happened, but there have been no changes.