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?