cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tijevancasteren Frequent Visitor
Frequent Visitor

Multiple Response Survey question

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Barmaleikin Frequent Visitor
Frequent Visitor

Re: Multiple Response Survey question

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.

1 REPLY 1
Highlighted
Barmaleikin Frequent Visitor
Frequent Visitor

Re: Multiple Response Survey question

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.