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 ?