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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive