table card for null value

My data looks like this, when id is blank, it means the file has not been used.  I wanted to create a table card to show which files have not been used.  In this case, I wanted to show file B, E in the table card.  But if I make selection in filter for Id in ' ' , nothing comes up.  

Can anyone give me some ideas why or maybe there is better way to present the list.

 

FileName ID

A              1

B            

C             12

D              2

E          

Best Answers

  • Cartergan
    Cartergan Contributor
    Answer ✓

    You may be able to do a Beast Mode to help with this. 

     

    Something like:

    CASE WHEN ID is NULL THEN 'Unused' ELSE 'Used' END

     

  • Neeti
    Neeti Member
    Answer ✓

    Hi,

    You can either use BEAST mode CASE statement or even MAGIC ETL(if applies to)-> REPLACE TEXT. CASE statement as below:

    (

    CASE WHEN 'ID' IS NULL THEN 'ANY OTHER VALUE' ELSE 'ID'

    END

    )

    Hope this helps!!!

    Thanks, Neeti

Answers

  • Cartergan
    Cartergan Contributor
    Answer ✓

    You may be able to do a Beast Mode to help with this. 

     

    Something like:

    CASE WHEN ID is NULL THEN 'Unused' ELSE 'Used' END

     

  • I wrote a whole long response to this, and apparently got logged off!!!  

     

    Basically...Domo hates null values!  

     

    Use magic etl to replace null values and empty text.  

     

    Beast mode will be limiting and doesn't solve tbe underlying issue, so I recommend doing it in etl.  

     

    Let me know if you have an issue fixing.  

     

     

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Neeti
    Neeti Member
    Answer ✓

    Hi,

    You can either use BEAST mode CASE statement or even MAGIC ETL(if applies to)-> REPLACE TEXT. CASE statement as below:

    (

    CASE WHEN 'ID' IS NULL THEN 'ANY OTHER VALUE' ELSE 'ID'

    END

    )

    Hope this helps!!!

    Thanks, Neeti

This discussion has been closed.