0 Replies Latest reply on Feb 20, 2012 1:34 PM by brookesteger

    Counting number of returning customers

      Tableau is pulling in our customer purchase history which includes User_ID, Purchase_Date, Purchase_ID.  Right now I have calculated fields set up to report on the number of unique buyers on a week by week basis. Looks something like the table below.


      Now I want to fill out column 3, which is a count of the users that  bought something in WeekEnding=X, but also bought something at some point in the past, excluding Week X,  Ie they are a returning buyer. 


      Unique Buyer Count
      Returning Buyer Count


      Appreciate any insights on how to perform this calculation within Tableau.