Early noob questions and frustrations around filters in analyzer

I'm experimenting with Domo and I'm trying to recreate some powerBi reports. I have successfully connected to our Jira instance for issues and I'm now trying to create some visuals and reports based on the "issues" database.
One of the charts I'm trying to build requires me to filter based on a date field containing a date. Seems simple, right? However I cannot find a way to tell Analyzer to filter out all issues that are null/empty. How do I do this please? Note: this is not the card date filter for "last 14 days" or whatever, this is the "filters" column where I've dragged in the date field and want to set it to not show issues without a date.
Also another card requires that a single issue_type field does not contain one of three values: Epic, Initiative or Idea, and yet I'm unable to do this, it would appear. I drag the issue_type field to filters and can set it to exclude all issues that are Epics, for example, but I can find no way to exclude all three values, and I cannot include the issue_type field three times.
Am I missing something obvious or is Domo unable to do this kind of thing?
Best Answer
-
@carled Whenever you are filtering based off of whether a field is null, you will need to create a beast mode field that uses the "is" operator to check for nulls or the IFNULL function to assign a value to rows with null values. Then you can drag your beast modes into the filters section in the Analyzer.
- case when `Date` is null then 'Exclude' else 'Include' end
- IFNULL(`issue_type`,'N/A')
Note that this behavior is not specific to Domo. The filters in Analyzer behave like the "=" or "in" operators in SQL, which also do not capture nulls.
3
Answers
-
@carled Whenever you are filtering based off of whether a field is null, you will need to create a beast mode field that uses the "is" operator to check for nulls or the IFNULL function to assign a value to rows with null values. Then you can drag your beast modes into the filters section in the Analyzer.
- case when `Date` is null then 'Exclude' else 'Include' end
- IFNULL(`issue_type`,'N/A')
Note that this behavior is not specific to Domo. The filters in Analyzer behave like the "=" or "in" operators in SQL, which also do not capture nulls.
3 -
@MichelleH That was really helpful, thank you!
0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 21 AI Chat
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 414 Distribute
- 122 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive