Hi there.
I am trying to get a stacked bar graph with three measures for the bars and another two measures to draw two different lines. I know how to do everything except for the final step: the second line. I attach a twbx file with my graph, just in case someone could help me.
Thanks in advance.
4 answers
Hi There!
So if your real data source is also excel and if you have access to Tableau 9.0 or up, you can pivot the values 2 and 3 in the data connection window.
Then instead of dragging Sum(value) 2 and creating a dual axis, you can drag pivot field values on rows, create a dual axis and place pivot field names on color of the 2nd marks card:
