I have a dataset, whereby I need to condense time ranges from a sea of datapoints. For example, let's say I have the following script.
LOAD * Inline
My goal is to take all data points that occur within 3 minutes of one another, and combine them into a range. I would expect to get an endresult that looks like this:
2017-01-11 11:19:32 2017-01-11 11:21:32
2017-01-12 11:35:32 2017-01-12 11:37:28
I have a similar question where I've asked about a similar problem, but it concerned Packing Intervals where I had nice clean dates which would line up. With this problem, I'm looking at it from a minute sized granularity.