beast mode - counting text
I have a survey where the participants are able to select multiple options.
For example: Why did you decide to not enrol?
Answers: I cannot currently afford it
I am not interested
I cannot make the time
When I try to visualise this, it does not group single answers with cases where there are multiple answer choices selected.
I want to be able to count each of these options.
I was trying something like the following, but it does not give me the correct counts (which I can quickly do in excel).
WHEN `Why did you decide to not enrol?` LIKE '%I cannot currently afford it%' THEN COUNT('I cannot currently afford it')
ELSE `Why did you decide to not enrol?`
What am I doing wrong? Or is there a better way to do this?