Forum Discussion
Survey Analysis - Top/Bottom Scoring Questions
Hello: I am looking for some suggestions as to how to produce a table that shows the analysis of survey data. Of a survey containing 50-60 survey questions, we need to draft a table that show...
AJV So in general you are going to want everything to be unpivoted. So like:
ResponseID,QuestionID,QuestionText,Score
1,Question1,This is a question,10
1,Question2,This is another question,3
2,Question1,This is a question,10
2,Question2,This is another question,3
3,Question1,This is a question,10
3,Question2,This is another question,3
You do NOT want:
ResponseID,Question1Text,Question1Score,QuestionIDText,Question2Score,Question3Text,Question3Score...
Not sure how much more specific I can be given the information. @ me in replies.