Unpivoting your data would definitely be best practice here. It may be considerably more difficult, if not impossible, to create some of the visualizations you want with your data in this format.
With that said, if all you need to do is filter one question's results based on two other questions' responses, you could presumably
- Add each response field as a separate filter for each of the two multi-select questions you want to filter by
- Display side-by-side response counts for each of the response fields for the single-select question
Thank you so much for your response.
I am able to get what you are saying, it will be difficult to build visualization from this structure. Also, I agree, unpivoting the data is the best option. As I have already mentioned, unpivoting all the multi-select questions is not giving accurate results. But I was able to find a solution, i.e. unpivoting each multiselect questions individually, by this I have one single field for each of the question. After that, I created 3 parameters to make the comparisons, and all results were accurate, so finally solved it. Also very easy now to make charts as well.
I really appreciate your response