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