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

Discussion created by jvarasanz on Aug 14, 2018
Latest reply on Dec 28, 2018 by zach.robinson_sm.gov

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.