Creating Card filters on values currently absent from a dataset
Hello. I am trying to display a card that shows rows where are particular date column is absent of values.
Since null dates cannot be filtered on within cards, I have a Beast Mode formula that does the following:
IFNULL(STR_TO_DATE(Target Go-Live Date, '%d/%m/%Y'), 'Blank')
I am building out a card (for a Bar Chart, if it matters) to display records where the row's value is 'Blank' as this would be invalid. My dataset does not currently have any 'Blank' values, which is good and means users are adhering to processes! However, I want to configure this card to be prepared to "catch" mistakes in the future but consider the card "complete" in the meantime.
A similar question was asked in the past, but the answer assumed the ask was about Quick Filters. I would not want to use this as a Quick Filter. Is there a way to filter on values within a dataset if they are not currently present on the dataset?
Best Answer
-
You could configure a beast mode to return the opposite and then do a NOT IN
CASE WHEN Target Go-Live Date` IS NULL THEN 'Blank' ELSE 'Not-Blank' END
Alternatively if you're wanting to do that exact value then set the Blank value for when it's populated. Do your filtering then change your beast mode back.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
You could configure a beast mode to return the opposite and then do a NOT IN
CASE WHEN Target Go-Live Date` IS NULL THEN 'Blank' ELSE 'Not-Blank' END
Alternatively if you're wanting to do that exact value then set the Blank value for when it's populated. Do your filtering then change your beast mode back.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive