I have an Azure Streaming Analytics job that has an event hub as an input and a function as an output. With the stream of data, what I'm looking to do is to output the last X seconds of data every X seconds so that when the function in the output gets called, it is passed the last X seconds of data. Is there a way to achieve this with Streaming Analytics, or is there a better tool for this. I see there is a LAG function but I can't see how it can be used for this.