1 Reply Latest reply on May 22, 2013 5:06 PM by Alex Kerin

    Running Count Distinct for a date range

    R I

      I am trying to get a running count distinct but failing miserably!

      Date range=Day 1 to Day 7

       

      Day1=10 distinct users

      Day2=20 distinct users

      Day3=15 distinct users

      Day4=12 distinct users

      Day5=10 distinct users

      Day6=14 distinct users

      Day7=11 distinct users

       

      The result I need is supposed to be a running count distinct..so if i look at the total number of distinct users in the week it is 40 but the above list shows distint users each day..and total to 10+20+15+12+10+14+11. I can get distinct users each day easily using count distinct but I need to get distinct users each day starting day1.

       

      I need to get a bar graph that shows how many new users get added each day including the previous day's distinct users

       

      Eg-

       

      Day1=10 distinct users starting Day1

      Day2=13 distinct users starting Day1

      Day3=19 distinct users starting Day1

      Day4=25 distinct users starting Day1

      Day5=31 distinct users starting Day1

      Day6=35 distinct users starting Day1

      Day7=40 distinct users starting Day1

       

      I am attaching a sample data spreadsheet.

       

      Thank you!!!!

       

      R