Hey there,
i have read the forum quite intensively in the last months and have found great help for most of my questions already. Thank you all for this so much. I just love this community.
Now I have a problem which I could neither solve myself or find help for here.
I have merged together 2 energy sensors via SQL, which worked ok. One was an old Shelly sensor I used for the the grid energy I used to get from the grid. The new one is a Solax solar systems which has its own entity for it. I just have one thing I could not really solve.
Whilst all the values are ok, I do have a big negative value on one day. HA thinks I have bought 1000 kWh on that specific day. At least it does in the Energy Dashboard. I can not find that value in the SQL, not in the Developers Tools and not in the statistics of the entity. Screenshots of all this attached here.
Would anybody have a good idea how I can fix that?
Thanks for any help in advance.
Thomas
Put all the screenshots in one document for efficiency
