i don't think it is possible to create this graph with tableau cause you only have one "measure values" field per Sheet and you can combine only two measures as "dual axis".
For your view you would either need two "measure values" fields (one for the sums one for percents) or the ability to combine six measures as multi axis.
2 of 2 people found this helpful
If you have access to Tableau 9.0 or higher and your real data source is also excel then you can partly pivot your data (only for percents). Use measure values for non-percent values and pivot field names for percent values. But this will turn side by side bars to stacked bars if you can live with it.
In the data connection window, you can select 3 percent columns, right click and choose pivot:
Dealership on columns, measure values and pivot field values on rows. This creates 2 marks cards on the left. On the 1st one place measure names on color and on the 2nd marks card place pivot field names on color. Make it a dual axis and there:
This is nice. I wasn't aware of the possibility to pivot the data. Maybe because i never use excel datasources.
Yup this is nice. I can work with this. Actually when I changed the shape to circle instead of bars its look more meaningful. Awesome. Thanks for this Pooja. Also Thanks Roland.