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

      Hi,

       

      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).

       

      Thanks