
1. Re: How to plot running count of a dimension by month?
Hari Ankem Sep 16, 2018 1:50 PM (in response to Dian Jiao) 
2. Re: How to plot running count of a dimension by month?
Dian Jiao Sep 16, 2018 2:01 PM (in response to Hari Ankem)Sorry. Updated

3. Re: How to plot running count of a dimension?
Ken Flerlage Sep 16, 2018 3:56 PM (in response to Dian Jiao)I don't really see any issue here. If I count the distinct doors, I get 9026, which is pretty much the same number as you had.
That being said, I do think these calculated fields may be overcomplicating things. Instead of those, you could just drag Active Door ID to the rows shelf, change it to a Count Distinct Measure, then right click, choose "Quick Table Calculation" then "Running Sum"

4. Re: How to plot running count of a dimension?
Dian Jiao Sep 16, 2018 6:44 PM (in response to Ken Flerlage)You are right about the calculated field. Just do the running total on "Active Door ID" does just that. And the total is indeed correct.
However, when I tried to calculate the running sum of the other dimension "Email Addr" in order to count the total of technician by date. The number is much higher than countd(email addr). The running total of distinct "Email Addr" is close to 2400 to date. But the actual count of distinct email addr is just 524. I have no idea where this discrepancy comes from. Workbook attached.

Door Tech Plot.twbx 10.5 MB


5. Re: How to plot running count of a dimension?
Sankarmagesh Rajan Sep 16, 2018 10:43 PM (in response to Dian Jiao) 
6. Re: How to plot running count of a dimension?
Dian Jiao Sep 17, 2018 5:31 AM (in response to Sankarmagesh Rajan)Hi Sankar,
Actually the 524 is the correct number at the end of plot. If I do "countd(email addr") without any time constraint, that's exactly what the total distinct count of email addr. I want to show the growth of "email addr" so I am not adding number of "email addr" for every month. How is this 524 number calculated in your example? How do I plot the growth of "Email addr". Doing running sum always ends up with 2325 at the end of the plot.

7. Re: How to plot running count of a dimension?
Hari Ankem Sep 17, 2018 3:17 PM (in response to Dian Jiao)You should join your data with another file/table that can give you a list of all the month numbers. You can then achieve your desired result.
To show how it works, here is what I did:
1. Copied the email address and ETL Insert TS into an Excel file; and created another sheet called Month Numbers with the values as shown below:
2. Joined the above data in Tableau as shown below:
3. Created a calculated field to trim the email addresses and have them all in lower case, and then did a distinct count on them. No, table calculation is required here.
Note: Your count of 524 includes some duplicate email addresses.
Attached the data file and a 2018.2 workbook. Hope this helps.

Technician Visit Data.xlsx 539.8 KB

Door Tech Plot.twbx 11.3 MB


8. Re: How to plot running count of a dimension?
Ken Flerlage Oct 8, 2018 5:38 PM (in response to Dian Jiao)Hi, just following up on this one. Let us know if we can be of any further assistance.