I'd like to be able to sum counts from all records since a fixed time in the past, rather than use fixed windows.
This would be like a sliding window, but with a fixed beginning, and an end that follows the last sample.
sesID TIME count
session1 time 1
session2 time 2
session2 time 3
The first step would be to create an subquery that uses LAG to find where the sesID changes, and then store that time.
That time then could be used as the start of the window, let's call it fixedStartWindow(StartTime, last(time)) and allow group by.
The output at this point, with session2 start as the start point, sum([count]) would be 5
From what I've seen, this cannot be done at present.
Actually, I hope I'm wrong.