Hi Mark! Sorry you've been so frustrated. This is a pretty easy thing to fix -- your problem is that you haven't reshaped your data, so Tableau sees each of these questions as a separate one, instead of seeing them as different subgroups of the same Question.
Reshaping (or as Tableau calls it, "Pivoting") is a very straightforward process. Our own Steve Wexler has done a great post on this process in Tableau 9 (which I hope you're using!) here: Reshaping Survey Data with Tableau 9.0 » Data Revelations
If you're using an earlier version of Tableau you'll need to use the Excel Tableau Add-In to do reshaping (unless you're using something like Alteryx) but it's also very simple. Here's an earlier post from Steve that predated Tableau's built-in reshaping capabilities: Using Tableau to Visualize Survey Data — Part 1 » Data Revelations
If you can share your data (or part of it) I'd be happy to demonstrate what you need to do. I'm using Tableau 9 so you'd need to be as well. If you are, hit me up and we can get this fixed for you very quickly.
I know it must be something simple. I’m at Stanford and we are stuck with T 8.3.5 because we can’t get anyone to update the server to take 9.0. We are having a meeting on that June 2, but for the time being it looks like we’ll be working with 8.3.5. Where do I get the Excel Add-In?
Here is the data for this problem … https://www.dropbox.com/s/0qik784d4cmq1ao/emstab.xlsx?dl=0 ... columns M-T are Likert questions where the answer was 0 to 4. Ideally, I’m shooting for a *Data Visualization* chart that looks like this …
but since I can’t even get them to fit side-by-side I’m feeling like this is a long way away.
Thank you, thank you, thank you, thank you, thank you … you get the idea!
Ach! The Excel Add-On to Reshape Data for Tableau is not available for Mac Excel. I'm pretty handy with R. Is there a way to reshape data using R?
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!
Schar Data Reshaped.xlsx 5.4 MB
Suddenly, the scales have fallen from my eyes! Of course, to quote the world famous Steve ... "data bases like to be tall and skinny." R has a package called "reshape2" that "melts" a data base into this form and then you cn "cast it in a new shape. After this, I can filter for the variables that I want. Perfect. You've given me a fresh start. Thank you so much!
You're most welcome. Once your survey data is tall, the world is your oyster! Please let me know anything else we can do to help you. So glad you asked your original question!
I've got 4 Liker like questions with a 1-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
Any one please help me how to create stacked bar chart.
Please read Steve Wexler's awesome tutorials at Visualizing Survey Data – Data Revelations , they will walk you through how to build out the stacked bars, the last steps would be placing the question dimension on Columns and the % answered measure on Rows.