Filter NULL values within Analyzer
I'm trying to built a basic table card that only shows records where the Brand attribute is NULL. I know for a fact that there are records that meet this criteria in my data set, as shown in the image below.
What's puzzling is that when I apply the filter, it doesn't return any records.
The filter works as it should for every other Brand, just not a blank field. What am I doing wrong?
Best Answers
-
Domo can’t recognize a filter to show null records. The easiest thing to do is create a new field with a beastmode that is something like this:
CASE WHEN Brand IS NOT NULL THEN Brand ELSE ‘null’ END
Null values will then be replaced with the word Null and you can apply the filter as you would normally.
you could also use IFNULL() or COALESCE() functions to accomplish the same thing.
If I solved your problem, please select "yes" above
3
Answers
-
Domo can’t recognize a filter to show null records. The easiest thing to do is create a new field with a beastmode that is something like this:
CASE WHEN Brand IS NOT NULL THEN Brand ELSE ‘null’ END
Null values will then be replaced with the word Null and you can apply the filter as you would normally.
you could also use IFNULL() or COALESCE() functions to accomplish the same thing.
If I solved your problem, please select "yes" above
3
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive