3 Replies Latest reply on Jan 22, 2019 3:39 PM by Hari Ankem

# Percent of total per year over 5 years

I am hoping someone can help me. I'm definitely not at the advanced level in Tableau yet! I am trying to get a percent of total per year over 5 years.  I have 5 years of Yes/No answers and need the percent of total for the yeses. I have been trying all week and can't figure it out.   I hope my attachments help - I'm desperate!

For example:

For 2018

Total=44

No = 31

Yes = 13

I need the percent of 13 out of 44.

THEN

For 2017

Total = 42

No = 42

Yes = 15

I need the percent of 15 out of 42.

• ###### 1. Re: Percent of total per year over 5 years

You can get it using Table Calculations as shown below:

Right click on the SUM(Number of Records) and do a Quick Tableau Calculation and then Compute Using Tableau down.

The 2018.3 workbook is attached. Hope this helps.

• ###### 2. Re: Percent of total per year over 5 years

Hari, I have another part to my dilemma.  I want the label to show both the

count and the Percent of total per year. They both show up on the tool tip,

but I need them both on the label.  I'm sure this is an easy thing to do,

but I've been working so long on this thing I can't even think straight

Thanks! Darlene

On Fri, Jan 18, 2019 at 3:08 PM Hari Ankem <tableaucommunity@tableau.com>

• ###### 3. Re: Percent of total per year over 5 years

You can drag the Number of Records measure and place it on the Label marks once more. You can then re-order as required by editing the Text mark.