1 Reply Latest reply on Nov 29, 2018 7:17 PM by Jennifer VonHagel

    Bar Chart showing values and Line Graph showing (only one) percentage line

    Kevin Keoghan

      Hi

       

      I am trying to do something that I thought would be easy but I can't get it to work properly.

       

      I am trying to get the below graph to show the count of a dimension but on the secondary axis show the value as a percent of each weekly total.

       

      I can get the bar chart part to work but i cant get the line graph correct. If I use tableau defaults it either puts in both lines and I dont want that, or if i try a calculated field I get all sorts of weird results.

       

      All I want is one line (that I drew in blue) that shows the percentage of each week. 

       

      (I know its possible - I've done it before but i lost the file and cant remember how to do it.)

       

       

      Thanks in advance!

      KK