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!