Get the value of a sensor at a specific time

Hello all!

Here is my use case. I use a Shelly EM to monitor power usage in my home. When I run the dishwasher I see a distinct pattern in power usage. It looks like this:

Imgur

My plan is to be able to reference the old data points near specific time intervals (like comparing the values 15, 17, 19 minutes ago with a threshold of 2000), and other values with a threshold of lower than 2000, and declare that the dishwasher cycle is complete and fire a notification. (basically validate that the pattern has happened).

I see that a possible solution would be to use an SQL sensor (Sensor state 24 h ago - #2 by MaxK), but that means creating a bunch of extra sensors, that in turn create noise in the database, and it’s less than ideal.

Thanks

2 Likes