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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 968 Connectors
- 255 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 361 Beast Mode
- 19 Variables
- 483 Automate
- 101 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive