Sum of Monitor individual devices

[jammiejammie (Bert Geelen)]

I’ve been adding more and more energy monitoring sensors to my home assistant setup to get a grip on what is using power.
Now i’m running for a couple of months and it is giving me a good insight on how much energy a device is using.

Now the next step is to investigate my “blind” usage.
I find this is not so easy as it seems.

Here is an example of my Energy distribution of one month:

My Monitor Individual Devices looks like this:

Now to investigate how much energy is used for all the monitored devices combined, i need to hover on each bar, and manually calculate the sum of all devices.

For this example, the total for this month would be 372,45 kWh. My usage is 489,1 kWh.

The data is there, but looking at the SQL tables for historical data, create such a query and displaying it in a useful way is out of my league.

How should i approach this ?

[fversteegen (Frank)]

I am looking for exactly the same! Solution I have thus far is creating daily energy sensors and substracting them from the total energy consumed. This is, of course, quite a cumbersome task with around 20 consumption sensors.

Another route would probably be using some kind of SQL sensor to read energy values and use that in calculations, but my SQL skills are rusty to say the least…

[jammiejammie (Bert Geelen)]

Well the problem with creating a sensor is that it would not work for previous measurements.
Also adding or removing sensors in the energy dashboard would result in incorrect display.

The data is there… just needs to be added to the display

[fversteegen (Frank)]

Far from ideal, but I visualize it in the front-end.