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?
- 7.4K All Categories
- 13 Getting Started in the Community
- 151 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部