I'm sorry, this is a hopeless newbie question but I f*&ked around with this for two hours and can't figure it out. I've got 5 Likert like questions with a 0-4 response to each and I'd like to display them as side-by-side stacked bar charts with the % answered in each of the categories ... I've seen these all over the place but I can't figure out how to do it. I can create the bars, set measure to count, apply a Table calculation as % of total. However, every question I add stacks the bars on top of each other rather than side-by-side. I know it's something simple to fix, but I can't find it anywhere on the interwebs after (as I said before) two hours of trying.
I've attached a picture of what I've got and can't figure out how to get them to align side-by-side. Also, I've played with making the responses a Dimension (instead of a Measure) but when I set it to Count, it automatically turns into a Dimension.
Any help would be appreciated.
You're right about the Excel add-in -- it's only for Windows. I don't use R but apparently reshaping can be done - I found a reference to this: R Integration | Tableau Software
I no longer even have Tableau 8 or the Excel add-in, since I'm fully Mac and using 9 these days.
I reshaped your data for you using Alteryx. All questions except for F1 and Inspire (which was open text) have been reshaped into two new fields - Question and Response.
You can put Question in the filter area and select the items you wish to be charted on the same graph -- in your example you'd pick all the Likert scale items.
I'd show you but you can't open a workbook from me, and I can't save down to v8. Hopefully this would be helpful though -- at least you'll see what you're going for.
Let me know how it goes!
Susan
