How to show in dashboard power consumed in the last month per device in EUROs | Home Assistant | Page 1

hollow vessel Jul 17, 2025, 4:36 PM

#

I have around 30x Sonoff S60ZBTPF smart power plugs that monitor power usage on a lot of devices thru my house. (Image #1)

Those smart plugs exposes sensors: (Image #2)

Current in A
Power in W
Summation delivered in kWh
Voltage in V

Data in Summation delivered sensor is always increasing so I have created an Utility Meter Helper, but why is it increasing? The power consumption of TV should be off or always under 200W. Usually around 105W. (Image #3)

#

#

I want to show in Dashboard how much EUROs has each device consumed of electrics in the past month

#

or if possible to also have a graph for each month (consumed power + price for that month)

flint lantern Jul 17, 2025, 5:57 PM

#

why shouldn't it be increasing?

#

if you want to calculate the price of power consumption of a device, you need to create a template sensor where you multiple energy price * power consumption and then integrate that with an integral helper

static dew Jul 17, 2025, 6:11 PM

#

You're billed for energy usage, not power usage. Have a quick self study break about power and energy, that will probably help making sense why the energy sensor can't decrease.

hollow vessel Jul 17, 2025, 6:18 PM

#

So currently create Utility Helper is correct and I should do the same for all devices?

flint lantern Jul 17, 2025, 6:19 PM

#

what are you trying to achieve?

#

utility meter doesn't compute anything you dont already have

hollow vessel Jul 17, 2025, 6:21 PM

#

#

Just calculate price in EUROs for each device, how much it consumes in monthly basis.

#

and sorry for my bad English

flint lantern Jul 17, 2025, 6:23 PM

#

utility meter wont do that for you

#

#1395444065872511056 message << is what you need

hollow vessel Jul 17, 2025, 6:24 PM

#

Have removed my current Utility Meter

hollow vessel Jul 17, 2025, 6:26 PM

#

flint lantern https://discord.com/channels/330944238910963714/1395444065872511056/139546487743...

but won't price always increase? it wouldn't reset every month back to 0

flint lantern Jul 17, 2025, 6:27 PM

#

yes indeed. But there are multiple ways to solve that

#

for example you can use a chart that reads the statistics

#

I have an example for that here (Q11)

#

and you can also calculate monthly costs using utility meter, but you will first need the integral helper and provide that as input to the utility meter

hollow vessel Jul 17, 2025, 6:31 PM

#

for Input sensor in integral sensor I provide Summation delivered entity right?

flint lantern Jul 17, 2025, 6:31 PM

#

no

hollow vessel Jul 17, 2025, 6:39 PM

#

AI says to use utility meter that's why it confuses me

flint lantern Jul 17, 2025, 6:41 PM

#

but you were asking about cost

hollow vessel Jul 17, 2025, 6:42 PM

#

won't I need monthly consumption in kWh first in order to calculate cost from it?

flint lantern Jul 17, 2025, 6:46 PM

#

nope

#

if you have a fixed price per kWh you could make a template sensor that takes your monthly utility meter and multiplies it with the energy cost

#

but like I said, the better option is to integrate a cost * power sensor

hollow vessel Jul 17, 2025, 6:54 PM

#

so something like this?

#

just created utility meter so 0.01 EUR seems to be correct

flint lantern Jul 17, 2025, 6:56 PM

#

yeah, i'd make price_per_kwh a number helper so you can always change it easily in the future

hollow vessel Jul 17, 2025, 6:58 PM

#

thanks, I'm new to Home Assistant, so I still have a lot to learn

flint lantern Jul 17, 2025, 7:02 PM

#

but remember this only works if your energy price is fixed

hollow vessel Jul 17, 2025, 7:04 PM

#

To make my life easier I would just gonna take the average price

#

otherwise we pay different prices depending on hours

#

5 different prices depending on hours

#

and also season

#

and also if there is a working day or not

#

this would complicate things a lot if I want to make it really accurate

flint lantern Jul 17, 2025, 7:08 PM

#

it's not that difficult to make, plenty of people have it like this

hollow vessel Jul 17, 2025, 7:13 PM

#

Will this require a lot of nested if statements? 😁

flint lantern Jul 17, 2025, 7:18 PM

#

nah, just an automation that sets the current energy price

#

so you still compute the integral of energy price * power consumption

#

but energy price is a number helper which is set by an automation that changes the price based on a time trigger

hollow vessel Jul 17, 2025, 7:27 PM

#

Thanks will try this

flint lantern Jul 17, 2025, 7:43 PM

#

lots of examples of this on the forum btw

hollow vessel Jul 17, 2025, 8:04 PM

#

Damn those prices are insane

#

blok 2 = 0,912240
blok 3 = 0,162970
blok 4 = 0,004070
blok 5 = 0,000000

#

there is even free electricy from 00:00 to 06:00 and from 22:00 to 24:00 on non working days (holidays and sunday and saturday)

#

there are so inconsistent that I really need to implement time based

hollow vessel Jul 17, 2025, 8:28 PM

#

#

this should determine which block is currently in use and it auto refreshes every minute

flint lantern Jul 17, 2025, 8:47 PM

#

Why not just use an auromation

hollow vessel Jul 17, 2025, 9:08 PM

#

this is what I currently have:

#

current-energy-price template that gets updated every minute

#

integral sensor for hourly energy

#

and another template that would calculate cost

hollow vessel Jul 17, 2025, 9:32 PM

#

#

So 4 entities per smart plug (device)

#

will now wait few days to see if everything is okay for this television and if so, I will do the same for all other devices

hollow vessel Jul 18, 2025, 4:07 PM

#

#How to show in dashboard power consumed in the last month per device in EUROs