Count Occurrences in String
How can I find a string within a String?
My String looks like:
I am attempting to perform a count of occurrences like so:
round(count( case when `Reg Category` = 'G' and `Interest Areas` LIKE '%Pleural Effusion%' then 1 end )/count(*) * 100,0) As In_Training_Member_Pleural_Effusion_,
round(count( case when `Reg Category` = 'G' and `Interest Areas` LIKE '%Non-Invasive Ventilation%' then 1 end )/count(*) * 100,0) As In_Training_Member_Non_Invasive_Ventilation_,
count(*) As session_total_count FROM private_merge GROUP BY EventDate,SessionNumber order by EventDate, SessionNumber, session_total_count;
I DO NOT FEEL COMFORMATABLE USING LIKE!
Many of my counts end up as zero, which is not correct.
I cannot seem to get CONTAINS to work.
Is that a viable function? Any suggestions?
I have a hard locating a list of functions for DOMO.
- 7.4K All Categories
- 13 Getting Started in the Community
- 150 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 日本支部