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
This is the definitive thread for running count distinct: http://community.tableau.com/thread/122852