4 Replies Latest reply on Feb 8, 2016 7:20 PM by Nakarest Chumsuntivut

    Running total(Accumulate) distinct number by day

    Nakarest Chumsuntivut

      Hi Guys

       

      I know this problem might be ask many times in this forum, I try to search about this problem and found some similar thread but still cannot solve my problem.
      e.g. Running Distinct Sum or Total using COUNTD this should be most similar issue in my opinion.

       


      So normally I can use COUNTD(Customer ID) to calculate amount of distinct customer but this can be only distinct customer of each day not all period.

      As you can see in a picture total unique of customer is 1,130 but when I use table calculation to do a running total the number on last day shown as 1,480(it should be shown as 1,130).
      How can I do a running total without duplicate value from previous days.


      Thank you in advanced