Hello, i have rows in my database with status like this:
2019/12/09 23:00:37 home
2019/12/09 23:25:36 nothome
2019/12/09 23:58:21 home
2019/12/10 00:03:46 nothome
2019/12/10 00:16:46 home
Every change of status i have a new row…
Is It possible to count the time in the last 24h with status “home” and show in graph?
Importante thing is, in case of the example before, count last 1minute and 39seconds for 2019/12/09 and the other 3:46 for 2019/12/10 (both in status “home”)
Thank you so much!