jvarasanz

Filter data for fields populated with multi-select questions in Survey123

Discussion created by jvarasanz on Aug 14, 2018

I was wondering if there might be an easy way to provide a filter for fields completed using a multi-select question in Survey123.

 

Survey123 converts user input to this type of question into a string where selected values are separated with a comma and no spaces (e.g. "Option1,Option2,Option3"), so hard to use as a filter due to the large number of combinations. Filter options will also look quite informal and out of format.

 

As a workaround I have created a field for each selection that will add "1" if checked or "0" otherwise. I can then bring each individual field to the filter and have an action that will update the others depending of the selection. However, this solution requires patience and a advance level in manipulating dashboards that make it pretty inefficient.

 

Please advise.

Outcomes