Running Distinct Sum or Total using COUNTD

tableaucommunity@tableau.com — Thu, 28 Mar 2019 18:24:32 GMT

Hi all,

I know this has been discussed in previous threads but I'm finding it difficult to replicate solutions to solve my problem.

I'm able to use the COUNTD([ClientID]) function to easily calculate the distinct amount of clients seen for a specific week which works perfectly. However, I'm also trying to represent on the same chart a running total (using table calculations) but Tableau doesn't seem to follow the same distinct count and simply sums up the distinct amount of clients. So at the moment my data looks like this in Tableau (using one city as an example):

City	Week	Unique Clients	Unique Clients Running Total
Melbourne	06/12/2009	1	1
Melbourne	28/02/2010	4	5
Melbourne	23/05/2010	1	6
Melbourne	15/08/2010	2	8

However, by 15/08/2010 there has only been 4 of the same client. Is there a way to make Tableau perform a running distinct sum or total using a calculated item which uses COUNTD?

I have attached a packaged workbook which includes a sample set of data and where I have got to so far. It would be good that this would work with date quick filters. Any help would be appreciated!

Thanks in advance!

Content in Tableau Community Forums

Running Distinct Sum or Total using COUNTD