locked
Interval of signals RRS feed

  • Question

  • Hi

    Stream analytics is doing a great job when you have a single timestamp parameter. But how can I have two?

    In other words my telemetry data is organized in a way that each signal has a going-up time and a going-down time instead of a single "happened time". I want to count how many signals are up at the same time (inside a long enough SlidingWindow of course).

    Any ideas?

    P.S. I was struggling with an sql statement that counts number of rows which have intersecting interval start and end columns. But my sql requires that I can order my rows on both start and end. I can use TIMESTAMP BY in stream analytics to order on interval start time but I was not able to find a way to order on one more column inside a SlidingWindow.

    Monday, June 29, 2015 1:48 PM

Answers