Forum Discussion

Tijevancasteren's avatar
Tijevancasteren
Regular Visitor
9 years ago
Solved

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 we...
  • Barmaleikin's avatar
    9 years ago

    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.