Please could you include the third measure in the workbook?
You can create one combined axis chart and then a dual axis chart.
It'll be something like this (but the data I have has more points):
Thanks and please see the attached workbook.
Test_machine_v10.2.twbx 59.6 KB
Hi Mavis, thanks for taking the time.
I´m not sure I understand what you mean with "third measure". There´s one real measure (measure 1) and one output (Output1).
In that workbook, you can also find the theoretical behavior, which is one measure and one output.
Did that help?
Barata and Mavis,
Sorry for jumping in.
Just wanted to throw out another suggestion.
If you have control over the headers of your datasources,
it may work easier if you could rename the ones in Expected
to match the ones in Behavior. Then you could union the two sheets
and plot one field against the other.
(That is, if your datasource type allows: Union Your Data
This can also be done in Tableau Prep)
If you are not able to change those, you can still union them
but then create a unioned Measure1 using:
IF ISNULL([Measure1Expected]) THEN [Measure1Behavior]
Similarly for Output.
Then you can plot unionedMeasure1 vs unionedOutput
and put the [Table Name] field created by the Union
on the Color shelf.
You can then make the line as a dual axis with
[Output1Expected] on the Rows shelf and [Measure1Expected]
on the Path shelf.
Please see workbook v2018.1 attached in the Forum Thread.
278118mach.twbx 54.3 KB
Nice workaround swaroop, thanks for contributing!