Card filter - Contains
Comments
-
Do you know the values ahead of time you're looking to filter with or were those to be generated on the fly based on your dataset?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Most of the time I will know ahead of time. But I would be curious how to solve both.
0 -
If you know all of the filter combinations ahead of time you can create a beast mode for with case statments to then return the "filter name" and add a quick filter based on those predefined options
=Sunshine
CASE WHEN lower(`field`) like '%sunshine%'
'Yes'
ELSE
'No'
END=Mountain
CASE WHEN lower(`field`) like '%mountain%'
'Yes'
ELSE
'No'
ENDThe downside with this approach is that you'd have several different filters a user would need to scroll through and maintain.
Upside being you have more flexibility and less things to click on assuming you have a long list of possibilities.
The other option is to add a quick filter for a text field (default Select All being unchecked and save your users a step) and then in the search text box you can add the wildcard character % inbetween your values. This will display any values which match those values however it is order dependent so you'd need to search "Sunshine%mountain" and "mountain%Sunshine" and select the resulting values listed.
Neither option is exactly ideal but are ways you could filter based on multiple contains.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Great post by @GrantSmith . You can also nest your CASE statement if that would cut down on your long term maintenance and in thise case just have one filter to check Yes to if you wanted see results for sunshine and mountains. It would look like this:
CASE WHEN lower(`field`) like '%sunshine%' THEN
(CASE WHEN lower(`field`) like '%mountain%' THEN
'Yes'
ELSE
'No'
END)
ELSE
'No'
END**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 74 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive