My individual numbers look right, but the result looks wrong

Energy
1

I have recently configured my energy dashboard to read from my egauge. Everything looked good for the first day, but since then the Energy Distribution widget is wrong even though the individual source values look to be correct.

I documented my set up and configuration in another post (when it looked like it was working properly): Setting up an eGauge in the Energy Dashboard

Here is what it looks like now:

image
image1503×1184 95.3 KB

You can see that grid to house (Grid consumption) is 0, house to grid (Return to grid) is 12.38kWh, and solar (Solar production) is 27.03 kWh. On the widget I would expect to see solar producing 27.03, 12.38 going to the grid, and the house using about 15. Instead it looks like the house is using nearly 40 and there is a dot moving from grid to house. It seems like it is adding the ‘Return to grid’ value to the power used by the house.

Any idea what is wrong?

2

I guess that the big spike of midnigh is the cause. The purple bar represent the “house to grid”, and it must be a negative value… instead it seems that you have a quite huge spike at midnight of positive value of + 20/25 kWh (wich by the way is A LOT of energy).

When i see this spike, I imeediately think about some wrong value returned from integration / PV. you can try to investigate / fix it using the statistics tabs of Developer Tools: Link to Developer tools: statistics – My Home Assistant

3

Yeah, I have to assume that is a sensor error and seems to happen the same time each night. Even so, I am not sure how that would impact the Energy Distribution since that is a real-time(ish) representation. I will dig around and see if I can figure out how to mitigate that nightly spike in any case.

4

I read an old post related a similar behaviour in Huawei PV integration. After a firmware update it seems that all the inverters started to have this kind of behaviour. The first reponse from the comunity was to provide a code for template sensor with some logic to “mitigate” as much as possible, the spike.

5

It is not real-time. It is an energy summary of the entire selected window.

If you have a specific day selected, it represents the sum of all flows during that day. If you have a year selected, it is the sum of all flows during that year. etc.

So whatever data was recorded in the 12AM window definitely affects it.

6

I think the real issue is the negative numbers. None of my sensors produce negative readings, so how am I getting negative readings in the panel?

For example, today’s readings my Electrical Usage is showing -19.2

image
image341×375 9.27 KB

It is showing -5.17 in my Sources:

image
image874×242 7.63 KB

Clicking through to the History shows 14.8 with no negative values, which is what I expect since that sensor only produces positive values.

image
image542×456 21 KB

The -19.2 matches the big drop in the reading between 11:55 and 12:00 (which I assume is the daily sensor resetting) but it is never negative. At worst it drops to 0. I have no idea where the negative values are coming from, but that definitely messes with my readings.