1 2 Previous Next 16 Replies Latest reply on Jul 30, 2018 8:23 AM by Don Wise

    Create Bins for Count of Occurrance

    Jordan Brogden

      Hi,

       

      I'm wondering if anybody can help me to crack this challenge I've got,

       

      I have a huge list of bookings (we are a travel company),

       

      Each unique customer has a unique Customer ID.

       

      A customer can of course book more than once (repeat traveller).

       

      I need a way to put into Bins, the Counts of the Customer IDs,

       

      So I need bins which are for example:

       

      Travelled once (Customer ID appears once in period)

      Travelled twice (Customer ID appears twice in period)

      Travelled 3-5 times

      Travelled more than 5 times

       

      In a given year.

       

      I hope that makes sense. I can create a calculated field to count the occurrences of an individual Customer ID - however I cannot create Bins off the calculation to group the data into those who have travelled once, twice etc.

       

      My data looks something like this

        

      Booking NumberCustomer ID(Count of Customer ID)
      1234566Cust_2087341224
      1234567Cust_2087341224
      1234568Cust_2087341224
      1234569Cust_2087341224
      5234567Cust_2087341263
      5234568Cust_2087341263
      5234569Cust_2087341263
      3655886Cust_2087341292
      3655887Cust_2087341302
      6655448Cust_2087341311

       

       

       

      Any help would be greatly appreciated.

       

      Thanks,

      Jordan

        1 2 Previous Next