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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 526 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 440 Beast Mode
- 23 Variables
- 514 Automate
- 115 Apps
- 391 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 67 Manage
- 67 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive