What is the best practice for this:
In my survey I have a select multiple question. We are now trying to integrate a dashboard with the survey and we need counts (Indicator element) of that select multiple question. Is there a way to parse out what we need or do we have to reconfigure the select multiple question to a select single question(or something else). Example: select multiple question answer is food, water, shelter all in one field. Can I get the counts of every time food is part of the answer or water is part of the answer?