6 Replies Latest reply on Sep 14, 2018 8:02 AM by Ankit Bansal

# How to group a bunch of phone numbers?

I'm trying to make a bar chart for a national hospital booking platform and need to make a table regarding how many patients had booked how may appointments have been booked. The format my boss wants it in is that he wants to see how many patients used the platform once and how many patients used the platform twice and so on and so forth. I have a spread sheet in which i have a bunch of phone numbers which are also repeated. The chart i am able to create is showing me how many appointments a certain phone number is making but if there are 12 numbers that made 6 appointments and 18 numbers that made 5 appointments, how will i be able to group numbers in accordance to how many appointments are being made?

• ###### 1. Re: How to group a bunch of phone numbers?

Hi

Here I have attached sample data which I created for this view and Tableau bar chart as well which combined number of appointment by mobile number.

THis is the data which i used.

Best

Suman

• ###### 2. Re: How to group a bunch of phone numbers?

This is currently what i am able to do, but i need a way to group data so that if there are 12 different phone numbers that have made 18 bookings and 16 phone numbers that have made 11 bookings then i want it to show on the x axis a range between 0 - 18 and on the y axis a range of 0 - 16. that way i will see how many people made 18 bookings and how many 11 bookings and how many made 1 bookings.

• ###### 3. Re: How to group a bunch of phone numbers?

I want it to look something like this

• ###### 4. Re: How to group a bunch of phone numbers?

Hi Umer,

If I am getting you correct,

You need an LOD calculation for that-> {Fixed [Phone Number]: Count[Bookings]} . This will  give you the number of bookings done per phone # and then you can take it from there.

Can you provide a sample workbook for better resolution?

Soham

• ###### 5. Re: How to group a bunch of phone numbers?

Can you post a sample data set? I think it can be done through Histogram and also some other possible approaches.

• ###### 6. Re: How to group a bunch of phone numbers?

Umer,

Attached is the workbook.

Thanks,

Ankit Bansal