2 Replies Latest reply on May 31, 2016 1:56 AM by Johan De Groot

    Count orders by recency

    Johan De Groot

      Hi,

       

      I am looking for a solution to get a visualisation which shows per month (year/week/...) the percentage of orders of that period from customer who ordered within the last 90 days, 365 days, 'ever', or never before.

       

      A simple representation of this would be like this:

      Untitled 2.png

       

       

      With some table calculations I can get pretty close (all orders from customers with a previous order within x days), but this only shows all orders per group (no calculations can be made from this, like count of total, percentage of total), and this can be a very slow workbook since the original datasource contains about half a million orderIDs...

       

      Attached a sample with superstore data - I hope someone can help me out with this...

       

       

      Kind regards,

      Johan