Filtering Against "Potential" Field Values

I'm trying to create a dashboard filter view for a set of field values where some values are not in the current data set but could be in time.
Right now, it seems I can only filter based on available data and not able to set up a filter for potential field values.
Is there any simple way to establish these potential values for a filter?
Thank you
Best Answers
-
I've done something like this by injecting a column into the dataset using a calculated field. As long as the name is the same, including the case. Later, I circled around and used the field with real data.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Do you want this to be a filterable value or you just want to filter out these values?
If you just want to filter out the values, you could do it in an ETL.
If you want this to be an option to select, you would need to add the value to the field and then just have a blank row of data beside the filter value in the field. Your data would end up looking something like this:
If I solved your problem, please select "yes" above
0
Answers
-
I've done something like this by injecting a column into the dataset using a calculated field. As long as the name is the same, including the case. Later, I circled around and used the field with real data.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Do you want this to be a filterable value or you just want to filter out these values?
If you just want to filter out the values, you could do it in an ETL.
If you want this to be an option to select, you would need to add the value to the field and then just have a blank row of data beside the filter value in the field. Your data would end up looking something like this:
If I solved your problem, please select "yes" above
0
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
- 87 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