Can you attach mock data and what you need ?
I don't know have you gone through this kb article or not?
Hope this helps.
That Interworks article a good technique for up to three measures, but doesn't cover the use case here, with two measures at one scale, and two other measures at a different scale. Ideally, you could drag in Measure Values twice, draw two axes, then have different measures in each of them, but Tableau doesn't currently allow for that. If you bring Measure Values in twice, it just duplicates the marks, and when you remove a measure from one group, it removes it from all groups.
There is a very old idea to fix this limitation. I don't have a direct answer, but perhaps some of the banter on this thread will yield some kind of acceptable alternative to the specific layout you need:
An ill-advised hack would be to duplicate measure values, and just manually force the axis for your percentages to be very small. The problem here is that all measures will show up on both axes, and marks will begin to get very confusing and there's no way to hide individual marks that may look like they belong to the wrong axis.
Got a screenshot of the Excel chart you are referring to? How are you dealing with the different scales between % and number values?
Thanks for replying everyone - i managed to fix it as one of the measures was actually a window avg of another of the above fields. So i did two in measure values against a dual axis on the third measure, then just added in a reference line for the final field.
Saved me having to explain why something simple in excel couldn't be done in Tableau!
Is there a ticket about to request this? Seems like it should have been done a long time ago!
Nice save! Reference line didn't occur to me, and you can cram in as many of those as you can stomach, assuming a straight line is all you need.