locked
Getting aggregated result of past events RRS feed

  • Question

  • Hi there,

    I was wondering if it was possible to get for example the average values of 45 min till 60 minutes ago?

    I was using a tumblingwindow of 15 minutes and joining it with a datediff between 45-59 which worked, but I then realised that this gets the average of upcoming events and not past events and thus takes one hour untill the average value result is outputted.

    I know I can use LAG to peek into past events but I can't find anything about using aggregates for this.

    Any tips would be appreciated, also please let me know if i'm wrong about what i'm claiming above :)

    Thanks.

    Wednesday, February 8, 2017 12:17 PM

Answers

  • You almost got the solution in your question :) Make first step to compute average of 15 min (I.e. Tumbling window of 15min) Then get lag(3), which is the window of 60 to 45 min ago.

    Azure Stream Analytics.

    • Marked as answer by lgortzak Thursday, February 9, 2017 8:15 AM
    Wednesday, February 8, 2017 5:34 PM