-
1. Re: Cumulative Count Distinct
kumar.c Dec 11, 2015 10:48 PM (in response to trevor.yip)Hi Trevor,
I made changes in the sheet2, is that what you are looking for.
Please find the attached workbook.
-
Cumulative Count Distinct.twbx 63.1 KB
-
-
2. Re: Cumulative Count Distinct
trevor.yip Dec 13, 2015 3:49 AM (in response to kumar.c)Hi Kumar,
My apologies... I'm actually hoping to update Sheet 1 (the line graph over time). I realize now that my original post does not have the right numbers, as you'll see below. What I'm trying to do is calculate the total number of distinct locations ordering to date (for that week).
i.e...
For week 1, we see 19 distinct locations ordering.
For week 2, we see 56 distinct locations ordering (this includes the 4 locations re-ordering.)
For week 3, we see 78 distinct locations ordering (this includes the 5 locations re-ordering)
etc...
I believe the reason is because for those locations that are re-ordering, they get counted as 2 (and higher for more recent weeks), which I'm guessing is why the count gets messed up when trying to do a running total.