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
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive