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.
