Fixing a gap in a prior post – Finding the Top Category with a Tumbling Window
In a prior blog post – http://blogs.msdn.com/b/appfabriccat/archive/2010/11/03/streaminsight-query-pattern-find-the-top-category-using-order-by-take-and-applywithunion.aspx – I discussed how to determine the top category in a set of events using order by and take. However, I only covered non-overlapping aggregate windows (i.e. Tumbling windows). I did not cover how you have to adjust your query definition for overlapping (Hopping) windows. Since this question came up in the forums, and it’s somewhat challenging to post a picture therein, here’s how you fix the problem.
See the original post:
Fixing a gap in a prior post – Finding the Top Category with a Tumbling Window
