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

    Days Since last Purchase

    Tableau Admin

      Hi,

       

      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.