1 of 1 people found this helpful
I don't know the answer to your question, but I do know that many folks recommend this site for information on visualizing survey data:
I'm pretty sure people are going to want to have a workbook to play with, to help with the solution process specific to your data. If you can attach a .twbx (packaged workbook) that would really help. Sanitize it if you need to i.e. remove/change sensitive data.
The resources at the link Matthew shared are highly recommended.
One of the tools mentioned on those blog posts is the Tableau Excel Add-in, which allows you to quickly reshape data for use in Tableau.
You may want to experiment with it when you have a chance:
I have attached a workbook to show you an example of what you can do with reshaped data. I used the sample data in your post.
questionnaire.twbx 27.4 KB
Working with survey data requires a little extra manipulation in Tableau. As Tracy Rodgers mentioned, we just started a Survey Data users group that I am moderating. Please come over and I know we can help you. Dallin Crump is right - check out the link - but I think we can help you further to work with your survey data.