7 Replies Latest reply on Sep 17, 2015 5:17 AM by Emily Chen

    window_sum/window_count

    Jon King

      I am having a little trouble with window_sum and window_count, and would appreciate examples if anyone has any. I have built a view with the following: 1) INDEX (ranking, top 10), 2) Customer ID 3) Customer first purchase >1 year (either '0' or '1'and is a measure based on purchase date, 4) customerfirst purchase < 1 Year (either '0'or'1'based on purchase date.

       

      I want to be ablt to 1) show a count of the numbers of customers in the window, 2) Count the customers that are in the column 'active < 1 year". Any help is appreciated.