1 Reply Latest reply on Jun 13, 2016 7:04 AM by Tina Hauser

# calculate unique users on a running period for a week alone

There is a table with Week number and User ID and we need to find the moving 2 weeks count of unique users.

i.e. we need to find the Unique customers collectively in week1 and week2 , then week2 and week3 , then week3 and week4 and so on.

In tableau we tried to get this result by using Window_Sum(CountD(UserID)). But Tableau is Calucating it as (Unique users of W1+Unique Users of W2) which is not the desired result.

Please find below sample table and the expected output.

Sample Data
Week User ID
W1 1
W1 2
W1 3
W2 3
W2 4
W2 5
W3 4
W3 5
W3 6
W4 4
W4 5
W4 6

Expected Output TableauOutput
Unique Users(W1+W2) 5 6
Unique Users(W2+W3) 4 6
Unique Users(W3+W4) 3 6

how to calculate unique users on a running period for a week alone -

• ###### 1. Re: calculate unique users on a running period for a week alone

Hi Rashmi!

Can you please clarify your expected output - specifically what is the "6" listed at the end of each expected output? W1 + W2 has 5 unique users.

Thanks!

Tina