Why it doesn't filter as I expected

eriena
eriena Member
edited March 2023 in Scheduled Reports

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_IDNameActionObject_TypeObject_NameEvent_TimePage nameCard Title
1AViewPAGEPAGEA2019/12/13 2:33PAGEA 
2BViewPAGEPAGEB2019/12/13 2:33PAGEB 
3CViewCARDCARD_A_A2019/12/13 2:33PAGEACARD_A_A
4DViewCARDCARD_B_A2019/12/13 2:33PAGEBCARD_B_A

 

test.png


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

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    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"

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    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"
  • eriena
    eriena Member

    Thank you very much for your advice!

    I could solved:)

This discussion has been closed.