How to group by elapsed time (gap detection)


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:
start stop
00:00 → 05:00
07:00 → 13:00
14:30 → 24:00

I found:

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.

Hello @Wolfspirit,
I’m not sure I know how to do that. I’m asking around for help.
Thank you for your patience. This might be possible in Flux, but I don’t think it’s possible in InfluxQL.