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
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 460 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 188 Visualize
- 251 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive