Would creating a group via a calculated field help? Something like:
if [Satisfaction]<=1 then '1'
elseif [Satisfaction]<=2 then '2'
elseif [Satisfaction]<=3 then '3'
Then, at least there would only be 7 different bars, although this could potentially make some of the bars way taller. I'm going to think about this one and see if I can come up with any other solutions.
Yeah I have thought about doing it that way, but like you say i'm stuck with how best to group the data together. I really don't want to do 1, 2, 3, 4, 5, 6, 7 as it won't give away any detail to the data.
Perhaps a bar chart isn't the best way to do this?
Any other solutions would be appreciated!
A bar chart is an excellent way to display the "spread" of the data for something like this, so I think you're on the right track. What you call groups sounds like what I think of as bins. You might try Tableau's built-in binning functionality, you can set the bins to be whatever increments of the 1-7 measure you like. You can read more about bins here: http://onlinehelp.tableausoftware.com/v7.0/pro/online/en-us/calculations_bins.html
Alternatively, you can build your own bins using a calculated field. I demonstrated some different options in this post: http://community.tableau.com/message/176844#176844.
That's perfect. Tableau recommended a bin of 0.6, but after playing with the bin sizes 0.2 works perfectly. Gives a nice clear picture of the data.