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
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive