10 Replies Latest reply on Apr 18, 2019 7:25 AM by Tijan Senghore

    Determining when a customer is active or inactive

    Tijan Senghore



      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