Is there a way to filter a card based on a sub-string in a text field?
mberkeley
⚪️
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).
Tagged:
0
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!**1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 344 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 467 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有