Task: There are a Survey which has Questions with multiple select answers/options. So, the task is to create an Event Program and later do analysis of the questions asked.
WhatWeDid: Currently the solution for multi select questions is to create DE for each answer with Yes/No option. For analytics part is to create Program Indicator for each DE with Yes/No and then create Pivot Table in Data Visualizaiton App using those Program Indicators.
This works but there one side effect. It is not possible (or I couldn’t find it) to share/filter the amount of events based on orgUnits. So, say there are orgUnit A with one Event and there are orgUnit B with 0 event. When there are a Program Indicator it takes in to account overall Events that happened within the Program but not filters it down to specific orgunit.
To sum up, in short, I want to know how do others in community implement multi-select questions and how do you do analyzes of such questions?
P.S. @dhis2-analytics looking for your expertise and community for this matter.