I’ve a device that sends data every second but sometimes there are gaps for 1-2 hours. I’m trying to display the times when the device send data on a timeline.
It would be nice if I could group data based on elapsed time < 5m. Is that possible? I would like to have a new group if the device stopped sending for 5 minutes.
What I would like to have is a table with:
00:00 -> 05:00
07:00 -> 13:00
14:30 -> 24:00
Which is pretty much the opposite of what I’m trying to do but I was wondering if there is an easier way for what I’m trying to do.