Why it doesn't filter as I expected

Hello all,
I created a card from the dataset. The card setting is as follows. When I filtered "Card Title" to be equal to "null" by QuickFilter, the count of action is expected to be 2. But actually The count of action shows 0. What was wrong?
Chart type = Bar
X AXIS = Name
Y AXIS = Count of Action
SERES = Page name
Quick Filter = Page name, Card Title
User_ID | Name | Action | Object_Type | Object_Name | Event_Time | Page name | Card Title |
1 | A | View | PAGE | PAGEA | 2019/12/13 2:33 | PAGEA | |
2 | B | View | PAGE | PAGEB | 2019/12/13 2:33 | PAGEB | |
3 | C | View | CARD | CARD_A_A | 2019/12/13 2:33 | PAGEA | CARD_A_A |
4 | D | View | CARD | CARD_B_A | 2019/12/13 2:33 | PAGEB | CARD_B_A |
Japanese--
このようなデータセットが存在します。下記の設定でCardを作成しました。
Chart type = Bar
X AXIS = Name
Y AXIS = Count of Action
SERES = Page name
Quick Filter = Page name, Card Title
Quick filterでCard Title = null を選択したら、Count of action = 2 になってほしいですが、実際は0 count of action になってしまいます。
何が悪いのでしょうか?よろしくお願いいたします。
Best Answer
-
Domo does not handle NULL values well in Analyzer
Create a beast mode
case when `card Title` is null then '-- no card title--' else `card Title` end
then you can filter on '--no card title--'
hope that helps!
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Domo does not handle NULL values well in Analyzer
Create a beast mode
case when `card Title` is null then '-- no card title--' else `card Title` end
then you can filter on '--no card title--'
hope that helps!
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thank you very much for your advice!
I could solved:)
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive