Filtering on Null Values
I have seen this question/idea opened and closed several times but I will submit again that a user being able to include or not include null values with a simple filter is important. I understand the ETL and beastmode workarounds but it is not scalable to have every request run through a limited data team just to find out which orders do not have an optional shipped date
.
Comments
-
@chris_schenk can you give me a specific example of where this null filter is not working? Are you taking about a cross card interaction filter based on a slicer? Could saved filter views potentially help here?
0 -
For example: I have a chart that shows order volume by sales channel (channel is in the series). I want to filter the channel by only those orders missing sales channel. If I select "Include" the blank values only, there is no data returned. If I select "exclude" and choose all of the other values, I receive the same result.
I can see that there are a lot of orders without a channel but cannot filter for these without creating a beastmode. I have seen this with string, date, and numeric values. The easiest way to reproduce this is by using the "selection" filter instead of the "range" filter
0 -
I am also experiencing this. It does seem like a bug to me because it leads to inconsistent and confusing behavior for the end user. For example, when I create a checkbox selector card on a field that contains null values, selecting anything other null impacts all cards on the page (assuming all cards built on the same dataset) but selecting the null checkbox has zero impact on the other cards. For all intents and purposes it looks like Domo is broken. As indicated in another thread, this can be addressed with Beast Mode or in a dataflow but from where I sit that's extra work with no added value.
0 -
It's definitely an issue that gets a question in the community forum every couple weeks. +1 for this request for sure. Here's the first couple I found with a search:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
@chris_schenk great idea, thanks for posting here. This is certainly a request we've heard before and is something we'd love to include in the product in the future.
Matt Tannyhill
Domo – Product Manager
Data Analysis & Visualization
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
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 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