For my Qualtrics surveys, I need to report on:

• Question-specific response rates (for a given QID, # responses / # times displayed)
• Percent of respondents selecting a choice in multiple-select questions (for a given choice, # times selected / # times displayed)

I don't see any way to do either with the current Qualtrics connector.

Displayed Questions
Question that are not displayed (e.g., hidden using Display Logic) to a respondent still show up in QUESTION_RESPONSE with null or empty values in VALUE & LABEL.  I propose that only displayed & unanswered questions appear in the table with null (or empty string) values, and that this functionality be well documented so we know what to expect.

Displayed questions data is available via:

• displayedFields in the survey response endpoint
• presence of a QID in other lists (values, labels, displayedValues) in the same endpoint, though the API documentation does not explicitly guarantee this
• Setting seenUnansweredRecode option in the response exports endpoint

Displayed Choices
In the current schema, data on displayed choices could be added in a DISPLAYED_VALUES column in the QUESTION_RESPONSE table.  DISPLAYED_VALUES could use a comma-separated list, as the current VALUE field does for multiple-select questions.

Displayed choices data is available via:

• displayedValues in the survey response endpoint
• "QID###_DO" (display order) keys in the "values" object of the survey response endpoint
• Setting breakoutSets = true and a value for seenUnansweredRecode / multiselectSeenUnansweredRecode in the response exports endpoint