I need to monitor total power usage of a freezer in the past 24h and look if it stays in the expected envelope. The easiest way seems to be an Integral helper and then a Template to subtract current and previous values? And a sql sensor defined in configuration.yaml (SQL - Home Assistant)? Sounds a bit involved and newbies immediately nope out of the helper menu when they see ‘Integral’ and editing configuration.yaml is a pain with restarts etc.
Have you tried Statistics helper? It seems to me it should do what you want.
If you don’t need an entity and just want it to be displayed on dashboard, you can use the statistic card instead, set to rolling window period:
1 Like