When you insert a filter and it pulls fields with nothing in them....
Hey just thought I would post a solution to a problem that I had recently. I was filtering out any sales that had "warranty" in the comments, but it would take out any sales where the comments box was empty. To fix this I entered a beast mode to get rid of the NULL values in my comments column.
CASE WHEN `SO_Comments` IS NULL
THEN ' '
ELSE `SO_Comments`
END
3
Best Answer
-
Problem Solved
1
Answers
-
It's good that you were able to find the solution
.
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0
This discussion has been closed.
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有