3 Replies Latest reply on Jun 7, 2016 10:18 PM by Ashish Chaudhari

Calculating Percentages on a Bin

Hello! I am looking for information on how to do further calculations (such as calculating percentages) on bins. I have already separated my 'Age' dimension into 5 bins, and I want to add two of those bins to see the percentage of the total records those 2 bins are specifically. I have tried various methods, but none of them have allowed me to add 2 bins together to find the percentage. Any help would be greatly appreciated!

• 1. Re: Calculating Percentages on a Bin

Sample data will be appreciated on which we can take this further.

• 2. Re: Calculating Percentages on a Bin

For example, I have the following 5 age groups: 'Under 5', 5-10', '10-15', '15-20', 'Over 20'. Each of these bins have a specific number of records. I want to add 2 age groups - 'Under 5' and '5-10' - and see what percentage of the total these two make up. So for the 'Under 5' category, there are 14 records, and for 5-10 there are 22 records, making a total of 36 records in the two bins. There are a total of 49 records in the data set among all 5 age groups. I want a calculation on Tableau that does this sum (14 + 36), and then will give me the percentage for 36/49 (73.37%). Hope this helps!

• 3. Re: Calculating Percentages on a Bin

Will it be a static? I mean this age grps which you have mentioned as a Numerator will be fixed? (Under 5 and 5-10) Also it will be helpful if you can draw the output the way you want or simple % value will do the job?