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. 

       

      WeekEnding
      Unique Buyer Count
      Returning Buyer Count
      2/11/124,232
      2/18/125,556

       

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

       

      Thanks!