1 Reply Latest reply on Apr 5, 2018 1:02 PM by Patrick Van Der Hyde

    Days Since last Purchase

    Tableau Admin



      Am trying to flag any customers who haven't ordered for 3 days or more but have come back after that as regained.


      I would like to get the date they were regained/came. So that means for every customer I would need to check their history and get how many days apart they ordered as soon as its 3 days or more mark that date as date we lost that customer. If they come back , I would like to know that date.


      This will help me know lost customers over time and regained customers over time.


      How can I do that?


      I have attached a sample workbook.