We have a survey app and the way we collect data from a multiple choice question now is by creating for each row an array with each option selected by the respondent separated by a comma.
Example: Which pet do you have at home? 3 options possible (cat, dog, none)
user1_answer = ‘cat’, ‘dog’
user2_answer = ‘cat’
user3_answer = ‘none’
I would like to show the number of time each of my 3 options comes out (cat 50%, dog 33%, none 33%)
However, the way Metabase shows the answer is by creating a 4th option ‘cat, dog’. which returns this: ‘cat, dog’ 33%, dog 33%, none 33%.
However, I don’t want to have that 4th option in my graph.
How can I only show unique options not combined?