Hello, I am working with survey answers which I can't share due to the content of those answers so I will use sample data to explain my question.
The survey has regular questions where one answers is possible which are not a problem to me. The problem lies with the questions where multiple answers were possible. Let me give you an example:
Question: Which search engines do you use?
How the answers were put into the dataset for each respondent: Google;#Yahoo;#Bing.
Now what I understand is that I have to split the answers into columns which would create the question three times for the same respondent and turns the dataset into the following:
Question.1 Answer.1 Google
Question.2 Answer.2 Yahoo
Question.3 Answer.3 Bing
The issue I have is that I want to filter on the answers with a slicer afterwards which requires me to select one of the three question columns. However this does not correctly represent the data.
This will only filter on the occurences where the answer in that specific column is equal to the filtered value.
What that means is that if I filter on people that have the value for Answer.1 = "Google" in the column for Question.1 it will filter those results, if Answer.2 and Answer.3 are equal to "Google" these will be disregarded which means the representation of my dataset in the visualizations is incorrect.
I want to be able to filter on all of those columns at the same time.
I hope my explanation is sufficient for you to understand. I am sure there is a way to do this, but I haven't found out how.
What I've tried is to split the answers into different rows but this would create a dataset that abnormally large so that cannot be the correct solution.
