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

    Percent of total per year over 5 years

    Darlene Fritts

      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.

      Etc. - please see attachment