I have following data containing
- a device
- a timestamp of when the deviced logged the event
- an event: ON or OFF
I would like to get a graph that shows per day the duration a device was active (duration = OFF timestamp - ON timestamp)
I can't figure out how to do this without manually creating a new table from my inputs like this
Raw testdata Edited
device timestamp action
frig1 21/07/2022 10:30 ON
frig2 21/07/2022 10:32 ON
frig2 21/07/2022 10:35 OFF
frig1 21/07/2022 10:38 OFF
frig1 22/07/2022 10:30 ON
frig1 22/07/2022 10:37 OFF
frig2 22/07/2022 11:30 ON
frig2 22/07/2022 11:35 OFF
frig2 22/07/2022 11:59 ON
frig2 22/07/2022 12:06 OFF