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

C 12

D 2

Find more posts tagged with

Accepted answers

Cartergan

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

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

All comments

Cartergan

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

DataMaven

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.

Neeti

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