I'm trying to visualize the SO Developer Survey in Tableau. I have a side-by-side stacked bar chart. On the x-axis I have job satisfaction, separated by gender. (So, columns: job satisfaction, gender, both are dimensions). On the y-axis I have "most important aspect of a job opportunity" (So, rows: measure values, with each value being a COUNT).
I would like each bar to total to 100% so for each value in measured values I have set the quick table calculation to "Percent of Total" and am computing using cell, but when I do so, every value appears to be equal/100% within the bars.
Can anyone tell me what I am doing wrong? Each value should be some percentage, all totaling up to 100%.
I was trying to follow this tutorial: http://kb.tableau.com/articles/howto/stacked-100-percent-bar-chart