Is there a way to filter a card based on a sub-string in a text field?
I have a text field that is delimited by '|'. I would like a user to be able to use a quick filter that allows users to find a sub-string of the text field.
Regions Covered
Row1: North|South|East
Row2: East|West
Row3: West
Row4: East|South
I would like to be able to filter if a row contains 'East'.
(Yes, I know I could do some magic to unpivot these values, but the # of rows would be obscene and there is limited value in keeping all those rows).
Best Answer
-
Hi @mberkeley
You can use the Contains filter on the quick filter. You just need to make sure you set the quick filter to use the "Match Values" option in analyzer and then the user will be able to select "Contains" as the filter option.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hi @mberkeley
You can use the Contains filter on the quick filter. You just need to make sure you set the quick filter to use the "Match Values" option in analyzer and then the user will be able to select "Contains" as the filter option.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive