7 Replies Latest reply on Sep 27, 2016 12:47 PM by James Dykema

# Population Pyramid as percentages

Hi,

I'm curious if there is a way to make a population pyramid in terms of percentage of total population? I have made a regular population pyramid with counts of gender for each age group and it looks fine. However, I would rather have it show the percentage of the total population instead of n in each subgroup?

Can anyone help?

Thanks!

• ###### 1. Re: Population Pyramid as percentages

Good Morning James,

It'd be most helpful if you could post (attach) a sample workbook showing more detail and the work you've done thus far.

That said, if you have what you want and simply want to show % of total rather than total N, then simply use the Quick Table Calculation "Percent of Total".

Here's a handy little blog post that walks you through it: Quick Table Calcs: How to Calculate Percent of Total in Tableau - The Data School

Best Regards,

Steve Burger

• ###### 2. Re: Population Pyramid as percentages

Hi Steve,

Thanks for the response. I have attached an example workbook here.

I understand what you are saying with the percent of total. However, for example, I am looking to show the percent of females that fall in the 25-29 age groups of the total workforce population. When I use the percent of total feature, I am only getting the percent of females that fall in the 25-29 age groups of the total female workforce population.

On the first sheet, I have essentially what I would like. I did this by creating a calculation of the n in that subgroup divided by the static number of the total population of the entire workforce. As you can imagine, I would like to be to have this 'static number' not be static, but instead be dynamic so I could run filters on it such as hourly/salary. Then --> the percentage of females that fall into the 25-29 age groups would change with my filters as the both the numerator and denominator would change.

Does this make sense? Is it possible?

Thanks again for the help!

• ###### 3. Re: Population Pyramid as percentages

Hi James,

Thanks for the clarification. Unfortunately, I don't think the attachment made it. I'm not seeing it, could you please retry?

Thanks,

Steve

• ###### 4. Re: Population Pyramid as percentages

Hi Steve,

It won't let me add it in this reply. However, if you go to the original post, are you sure it is not available there? If not, I will try something else.

Thanks again!

• ###### 5. Re: Population Pyramid as percentages

James,

• ###### 6. Re: Population Pyramid as percentages

Thanks!

James Dykema | Workforce Analytics I c:  616.901.3706

• ###### 7. Re: Population Pyramid as percentages

Hi,

Here is the document!