7 Replies Latest reply on Dec 12, 2016 5:41 AM by Shinichiro Murakami

    How to count distinct user on a running period comparing to the previous periods

    Alfie Econg

      Hi Everyone,


      Here is my requirements. I have a daily data.

      For requirement #1 I have to check the unique counts of customer id daily that were present on the last 7 days, Let say if there are 2 registrations today but they are all present on the last 7 days, then NO NEW registration for today. If they were NOT, then they were count as NEW registration for today.


      For requirement #2, I have to sum all the new registration daily. let say if today is Nov 3 and  new registration on Nov 1 = 1, Nov 2 =3, Nov 3 = 1 , then total new registration for today should be = 5.


      I really appreciate your help on this.