3 Replies Latest reply on Nov 19, 2018 3:07 PM by Hari Ankem

    Calculate Return Customers Over Time

    Alex Pak

      Hi everyone!

       

      I've been trying to created a viz of a number of customers per month that purchased that particular month for the first time after a 12 month period without making any purchases.

       

      I am attaching a global superstore data with some simplification as an example.

       

      Also on the screenshot you can see how I managed to calculate the latest purchase date, the one before last and the difference in terms of the number of month.

      Eventually I need to graph the number of accounts that have more than 12 month between the last two orders by month.

       

       

      Thanks for the help in advance!

      Alex

      Updated