I am a total Tableau newbie and am trying to convert some simple stacked bar charts being done in Excel to Tableau. In this specific case, I'm working Likert Survey data asking about Favorability. In the bar chart I want to display Very Favorable with Somewhat Favorable, then Neutral, then Somewhat Unfavorable with Very Unfavorable. I've set up calculated fields for Overall Favorable and Overall Unfavorable, but no matter what I do Tableau always displays the break out for each of the response type. I'm sure this something simple, but cannot seem to figure it out. The raw survey responses are text (Very Unfav, Somewhat Unfav, etc.) not numerical. Any assistance would be greatly appreciated
This is what I'm getting.
This is the end product I'm trying to get to.
The best resources by far for working with survey responses with Tableau are found at Steve Wexler’s blog http://www.datarevelations.com — and in his books like The Big Picture
