Crosstabs for Multiple Choice Questions | XM Community
Question

Crosstabs for Multiple Choice Questions

  • 23 October 2019
  • 2 replies
  • 166 views

Hello,

We need to create a crosstab that will be based on Response count instead of Choice count, since the row/stubs variable is a multiple choice question. However, after the platform migrated to new “Crosstab Experience”, we are unable to produce the crosstabs for multiple choice questions so that the Column Total equal >100%.
!

Any solution or workaround for the issue highlighted above is greately appreciated.

2 replies

Badge
I had the same issue with the new "Crosstabs Experience," in which you can't select Column Percentage (Answering) for checkbox questions. The quickest workaround I found would be to create and download the table with just Counts, and rebase/recalculate the %'s in Excel with the proper Response Count.

Alternatively, when I contacted Qualtrics Support, you could do so by creating a bucketing variable for the dataset, and rerunning the crosstab with the new bucketing variable, which you would need to do for all checkbox questions. :s
Badge
Having the exact same issue. Had the excel idea but was hoping for an easier solution. In the end that would still probably be quicker than creating a bucketing variable for each and every question.

Leave a Reply