Is there a way to use a matching value filter with a single select filter?

Hello!
Currently, the filter control options avaiable for Quick Filter are:
Match value
Single select
Multi-select
Is there a way to use these filter controls together? For example, I may have two columns with the following values:
Name Pets
Ann Cat, Dog, Bird, Reptile
Ben Dog, Bird
Kate Bird, Reptile
Tom Cat
Will Cat, Bird
I added a Match value filter to find all rows that contains "Cat" in Pets, but I only want to select a few of the resulting matches. For example, the match value filter returns:
Cat, Dog, Bird, Reptile
Cat
Cat, Bird
But I only want to select Cat and Card, Bird. Am I able to do this?
I would just do Multi-Select for a simple dataset (such as this example) but unfortunately my dataset may contains up to 100 unique values.
Best Answer
-
Complex filtering as you're asking isn't currently possible. If you're wanting to select specific values from the list then I'd recommend restructuring your data so that each animal appears on it's own line in your dataset and use a multi-select filter.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Complex filtering as you're asking isn't currently possible. If you're wanting to select specific values from the list then I'd recommend restructuring your data so that each animal appears on it's own line in your dataset and use a multi-select filter.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive