Why it doesn't filter as I expected

eriena

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 になってほしいですが、実際は０ count of action　になってしまいます。
何が悪いのでしょうか？よろしくお願いいたします。

jaeW_at_Onyx

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!

eriena

Thank you very much for your advice!

I could solved:)