In short, not really. Your most clear cut options are:
- Drop one of the measures and then create a dual axis chart that has one pair of measures on axis using "Measure Values" and the other measure by itself. Combine these on a dual axis
- Create a chart that stacks the pairs of metrics on top of each other. You would have all four measures on the rows or columns shelf, but they'd be paired into two dual axis charts.
Personally, I prefer the second option. It will take up a bit more dashboard space, but it's much more readable/usable.
Bars and Lines | Drawing with Numbers - lots of hacks and workarounds here; with any of these, consider the question, "is the juice worth the squeeze?"
You may also want to consider pivoting your data if that works in your scenario. E.g. if you pivot the percentage metrics for example, you would end up with a single column that contains both metrics and another column that has the name of the metric. You can drag the name of the metric on a shelf e.g. color shelf to get multiple lines out of one measures (which was more than one measure before pivoting). You can use measure values on the other axis and have the two metrics you want that have the dollar amounts. This way you will get all 4 metrics in the same view.
Note that pivoting will cause replication so you need to take that into consideration as well.
Please see the attached example workbook.
sample-dual-axis.twbx 51.5 KB
It's not possible to have 2 dollar measures and 2 percentage measures on the same graph You just can't do different Measure Names selections on each axis.
The only solution is to choose (even by a parameter) to choose which one of the two percentage measures you want to see, or which of the two dollar measures you want to see.
Thanks, I kinda tweaked it so I show some measures on one side and the others on the other. i forced the latter axis to go from 0-1. I cant get a % and a $ on the axis though but at least i have some version of what i envisioned. Thanks for your help!
+1 for Pivoting/Unpivoting the data instead! Tableau can do this on flat files (Excel) by default, but you can also use SQL languages like Presto or Hive to do this yourself in a Custom SQL query for Tableau's benefit: https://docs.treasuredata.com/articles/sql-tips#presto
Can you share steps in detail how to do Pivoting and plotting 4 measure on one chart... with your example ..
I am creating trends -line chart.
Question 1} How can I show 8 color different lines individually for Result: Pass - Fail and R2: Pass - fail, R3 -fass and fail, R4: Pass and fail on same chart? (Not combinations or aggregated)
Question 2} if i have some nulls in Result column how can i convert that null data in to 0?
Now I have successfully implemented above for two KI's Result , R2 - with dual axis
But I have requirement for 4 KI's Result, R2, R3, R4. All values will be pass or fail.
so total different colored line would be 8 -Pass or Fail.
Note: I do not want two dual axis with different axis in to same chart or
I mean i want all different colored 8 lines independently one chart ..
Thanks in advance.