Massive discrepancy in my energy dashboard

[ld9000]

Today, I modified the integrations I use to import data from my solar inverter into home assistant.

As a result, a few of my entities jumped by what seems like a few megawatt-hours, resulting in the system thinking I used >$1000 of power in one day (or one hour) :

(Both the Power meter Consumption and Power meter Exported values are incorrect, everything else is OK) - at this stage, I'd be OK if both of them are reset to $0 for the day.

I managed to fix the entity itself by going into Developer Tools -> Statistics -> Adjust -> Outliers.

But this does not fix the incorrect value that's already been computed by home assistant for cost.

This is going to throw off my whole year's energy calculation - any way I can fix it? According to the ol' LLM the only way is to go poking around in the DB and while I don't mind rolling up my sleeves I'd rather save this optoin as a last resort if I can.

[ld9000]

Classic. After searching on and off all day, I stumbled into this thread which lead me to the solution:

Energy Dashboard, Replace Entity but Missing Cost Data

I had this problem. I wanted to replace the entity on my Energy Dashboard for Return to Grid. I followed the same steps as you, and it worked apart from the cost, which showed as £0.00 as for you. I think the problem was that when you add an entity to the HA Energy Dash, it creates a separate entity (which is normally hidden by default), suffixed _compensation for export, or _cost for import. The relationship between the sensor value and it’s associated (monetary) entity is presumably reference…

I went to Developer Tools -> Statistics and searched for "NZD" which threw up ~8 entities.

I went through to the Adjust option for each one and into Outliers and sure enough turned up those values as seen; I just put them to $0 (this represnets about 1.5 hr of lost data which is no big deal!) - so this is cured now.