6 Replies Latest reply on Aug 17, 2018 9:24 AM by Jim Dehner

    Determining when a customer is active or inactive

    Tijan Senghore

      Hello,

       

      I have sales data and need to determine when a customer is considered active or inactive from the point they became a new customer.  I would like the output to show orderIDs as rows with "month" as columns and "active" or "inactive" as the result.  We are working under the assumption that on average, each qty of 1 will last the customer 2 months. So if someone orders 1 box in Jan, they can be considered active for both Jan and Feb. I'm attaching a packaged workbook - tableau desktop version 10.0.19.  Thanks for your help in advance

       

      TJ