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
-
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
1 -
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
1
Answers
-
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
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 726 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 302 仲間に相談
- 664 ひらめき共有