Smartapp that calculates the total time a door has been left open in the last 24h

Hi all,

I would love to have a smartapp that can inform me how much time a door has been left open in the last 24 hours.
Is that possible? I understand that some kind of data aggregation should be happenning (initial state comes to mind) in order to have this kind of functionality.

What do you think? Can it be done?

Thanks in advance

Yes, it can be done.

Hey @sidjohn1 do you know if there is smth already implemented?

Not that I know of, but I know ST records all the necessary data to calculate this and that the data is available programmatically. So the only think that’s missing is an app that turns the data points into something useful.