1 Reply Latest reply on Nov 19, 2013 3:34 PM by Joshua Milligan

    Group customers based on number of orders

    Jennifer Ceresia

      I'd like to create groups of customers based on the number of times their customer ID shows up in the order table (i.e. number of customers who've made 1 order, 2 orders, 3 or more orders)

        • 1. Re: Group customers based on number of orders
          Joshua Milligan

          Jennifer,

           

          There are several ways of doing this.  I've attached a workbook to demonstrate a couple of approaches.  The first uses a non-Cartesian plot and, while simple to produce, probably isn't quite as useful.

           

          The second approach uses a table calculation and a few other tricks to get to a solution.  I've attached a workbook with a tab for each approach (and scratch work).  I've also included a diagram to point out a few important points.  I'd be happy to answer any questions you might have!

           

          Regards,

          Joshua

           

          Simple (non-Cartesian):

          -1.png


          More Complex (Scratch Work):

          0.png


          Final View:

          1.png