Untracked consumption suddenly exploded

Hi,

Since a couple of days ago, my "Untracked consumption" suddenly exploded. I'm not sure why. There have been a couple of HA updates, but I can't figure out if that's the cause.

This is how it looked before:

This is how it has looked since the 23rd:

Any suggestions are welcome.

Thanks,

Rudi

I would suggest that your second screenshot is the correct one.

Lots of solar, with very little grid import (all energy sources on the left)
Then most of it goes to the home, with very little as grid export.
Then, from the home, most of it goes to untracked consumption, which is everything other than the tracked
Tracked - by floor, area, and finally device.

That just leaves your first picture, which is a bit of a mess, and I assume is missing the solar.

The purple 'grid' is export, so something is missing. Solar or battery?

Ah - of course - you have a solar battery but you have not added the battery charge / discharge energy sensors to your dashboard! Either that or your solar sensor is not working.

Other explanations are available.

@Biscuit

I have lots of solar, no battery.

Both pictures are confusing when you see them side by side, but I do agree the 2nd one is a correct view of the situation. I didn't immediately miss the solar in the 1st picture because I had consumption on my mind. But yes, solar should be there together with the grid.

The thing I can't explain is the large amount of Untracked in the 2nd picture, because I track 90% of my usage. And also, where is the Untracked in the 1st picture? :thinking:

Questions, questions.

I'll go through my setup again and see what's going on.

Thanks for your help.

The basic energy equation, if you have solar but no battery, is

Consumption = Solar + Import - Export

which the HA Energy Dashboard solves, for Consumption, based on the three energy sensors for solar energy, grid import energy, and grid export energy.

Working backwards, the 'Untracked' is simply all (calculated) Consumption less the sum of all the tracked items. This should work well, but clearly if the calculated consumption is too big, then there will be more untracked. If the calculated consumption is too small, then the untracked is reduced and may even not be there.

A (one) simple answer to your first graph is that solar is missing. Hence Consumption is too small (being just the grid import) and there is more tracked than (apparently) consumed, hence no untracked.

Likewise, for your second graph, there is either too much solar or not enough grid export, meaning that there is more Consumption than there should be, hence more untracked consumption.

The Energy Dashboard has a menu option to download all the data, which can be found on the first page, in the date selector box side menu. This will download a csv file with all the figures. You will get a column for every 5 minutes, but since these graphs only use the hourly stats, only every 12th column will have data in it. This provides the raw entity values, and the calculations done in stages to work out the total consumption.

This file does require picking out the bits you want, and adding a row sum, but it will provide the full period figures. Hence for yesterday, here is the critical part of the data for my electricity.

The untracked is just the calculated total consumption less the sum of the tracked items. And this is just what is plotted.

If you find that the tracked energy is greater than the consumption, or the consumption is much greater than you expect, then it is a case of going through each hour to find which, if any, are not correct.

Possibly the tracked is being double counted somewhere, so is too big. If I were to place a bet, then I would go for an issue with your solar sensor. If this goes unavailable for a time, then solar will be reduced, consumption reduced, and you get the first graph. If it then comes back and gets counted all in one go, solar is increased, consumption increased, and you get the second graph.

Thanks @Biscuit,

I'll definitely dive into it. But, with my attention span, I tend to be all over the place.
I just discovered MagicFrame with HA integration, and of course I had to install it. It just couldn't wait. :grinning_face_with_smiling_eyes: