Filter Field with LIKE based on another Field
Hopefully someone is able to understand what I'm trying to achieve and help with a solution.
I need to filter based on a "Tag" field with single text values, once selected would filter all relevant items in another dataset that has these tags in a single field "Tags" with multiple text comma delimited "tag1, tag2" for example.
Both created as a new beast mode "=tag_filtering" in both datasets to allow filtering.
Tag - "red" (used to filter)
Tags - "red,small" (needed to filter by)
My thought was a using beast mode something as below but have a feeling I may be well off, especially without having a wildcard % as part of the formula but having no joy, is this possible?
CASE WHEN `tag` LIKE `tags` THEN `GROUP_CONCAT(pt.tag)` END
Any input into the right direction is very much appreciated.
- 10.7K All Categories
- 13 Getting Started in the Community
- 39 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board