2 Replies Latest reply on Oct 18, 2013 8:54 AM by Matt Lutton

    How to Count Distinct for prior 30 days at a given time interval?

    Zafar Jafri



      Instead of the count distinct function by week, I was looking to have a count distinct function that counted everything for the prior 30 days in a given week.


      So for example, count distinct of Week 20, 2013 would give me a count of all distinct values for that week and the prior 23 days (cumulative).