Multiple Response Survey question

[Tijevancasteren]

Hello all,

I'm currently stuck on a project and I hope you guys could help me solve my problem. I have a database with 700 surveys, including some multiple response columns. My survey questions were Matrix-like questions.  Each statement has around 6 possible boxes to be ticked. This means I have a lot of columns with 1's and 0's, for each possible answer.  I want to group these answers somehow, and visualize them. Does anyone how to tackle these multiple response answers?

[Barmaleikin · Accepted solution]

Hello,

Faced the same thing but not for such huge amount of surveys. You could:

1. go to your Queries
2. duplicate the Query
3. Delete all columns except IDs and 1 Question with checkboxes
4. Select all collumns with answers to Checkboxes
5. Go to the Transform >> Unpivot columns
6. After that filter last column to disable zeros
7. Delete last column
8. Close & Load

You will get a table with ID and Column, lets name it "Selected Checkboxes" 

Throw IDs and Relationship type "1 to many", plus "filter in both directions", you could use slicers/demographic data from the main table vs Checkboxes answers.

P.S. Doing in this way also gives you an opportunity to use Checkbox question as Slicer to the main table data.