1 of 1 people found this helpful
Nevermind....found the answer at http://downloads.tableausoftware.com/quickstart/feature-guides/combo_charts.pdf
This appears to have been written for an earlier version but you should be able to apply to newer versions.
The posted instructions have 2 items graphed...I have 3. How is the process different???
The issue is exactly that you're trying to graph 3 metrics instead of 2. You can only use a Dual Axis, not Triple.
You can't create a Stacked Bar using two measures, it needs to be a single measure broken out by a dimension.
If possible, you would be better off using the Tableau Data Reshaper tool to alter the structure of your data.
If you instead had it in the following shape:
You could create two calculated fields:
- Actual & Variance
Where Actual & Variance would be:
If [Metric]<>"Standard" Then [Value] End
And Standard would be:
If [Metric]="Standard" Then [Value] End
Put both of these on your Rows shelf.
And on the Colour shelf for 'Actual & Variance' include [Metric] to split out by colour.
The 'Standard' entry still comes through on the colour shelf, but you can just hide it...
Attached is a workbook using dummy data to illustrate the point.
Hope this helps!
Sample Solution.twbx.zip 16.4 KB