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

    Rashmi sr

      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 -