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

    Count orders by recency

    Johan De Groot



      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,