1 of 1 people found this helpful
There's some good white papers available on this - https://www.tableau.com/sites/default/files/media/whitepaper_surveydata_v4.pdf
I work with survey data a bunch, and I think the first thing you would benefit from is pivoting your dataset. A structure like the following will help you do analysis across questions much easier:
Respondent Question ResponseValue Peter Q18 Yes Peter Q19 No Peter Q20 No Peter Q21 Yes
Take a look at the Pivot functions in the documentation for some help on performing this on your Excel file.
Thanks for providing that information, thats great! do you happen to have an example image of the graphic I can create when I structure the data in this way? I think the document just shows the data tables,
Thanks very much for your help.
1 of 1 people found this helpful
I mean honestly, you can almost create any graph you want with your data structured like that. You can put your question on the rows shelf, put the number of records on the columns shelf then drag the ResponseValue on to the color shelf and you'll have a stacked bar, by question broken down into colors based on yes / no.
Thanks for your advice, I have tried this but I cant seem to go the right way about it,
I cant seem to get the question bar x-axis to show me the question numbers so that I can see how many 'yes's' and 'no's' for each question but all in the one graphic?
I have attached my packaged workbook maybe you can see where I am going wrong?
Thanks for your time I really appreciate it!
Tableau Packaged Workbook.twbx 405.8 KB
I think you might need to invest a little time running through the basics of Tableau - I highly recommend the free training materials - Tableau Training and Tutorials
In the example you've built - you need to right click 'Number of records' on the column shelf and change it to Measure > Sum
You need to right click Question on the rows shelf and select 'Discrete'
I'm sure at some stage you will want to look at the 'percentage of responses' per question, so here's a bit of future advice on creating a table calculation. Once the above is done, right click Sum(Number of records), select quick table calculation, percentage of total. Right click it again, select compute using, table across. This will calculate the % of the total within that question.
Wow you really are a tableau superstar!
Thank you so much for your help, it would have taken me days to get there!
Thats amazing and exactly what I was looking for!
I'll have a look at that document on my way to work and see what else I can have a go at!
Thank you for your time its much appreciated!
Sorry to bother you again but I am trying this pivoting on another graph as it worked so well, but I am unable to change the order of the variables on the rows shelf, so that I can see each respondent and then their response 1-10 on each of the questions.
Do you know how this may be done? Below is how I have got it to look currently but I cant seem to get it to be shown by user first on the right hand side, then next to this broken down the 7 sections: Demo, direct, easily access... etc...
I have attached my workbook too if its hard to make out in this screenshot.....
Tableau Packaged Workbook.twbx 471.5 KB
Because respondent has been detected as a measure. You should drag it up from the measures pane to the dimensions pane.
In your view, you need to right click respondant and select 'discrete'.
I'd really like to recommend again that you step through the training, you're going to keep stumbling on things like this!