I’ve been wracking my brain on how to do this in influx. I have a query I run daily that gives me durations of different events (using _level). I put this into a task to run daily, but the issue is the end of batches. If an event doesn’t end at the end of the batch time, how do I continue counting the duration of this event in the next task run? I read over: Track state changes across task executions | Additional resources | InfluxData Documentation but it’s a little different of a situation as that is monitoring state changes and not calculating durations.
My one thought was to get the last row from the previous task run, and union it into the next task run. Is that possible? That essentially means that the event that spans two task runs would be completely included in the latest task run. Has anyone written a query like this?
Thank you!
