Skip to main content

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_20873412241234567Cust_20873412241234568Cust_20873412241234569Cust_20873412245234567Cust_20873412635234568Cust_20873412635234569Cust_20873412633655886Cust_20873412923655887Cust_20873413026655448Cust_2087341311

 

Any help would be greatly appreciated.

 

Thanks,

Jordan

17 answers
  1. Jul 26, 2018, 7:09 PM
    posted a file.
0/9000