Beastmode suggestion for a filter

Golfoholic
⚪️
I have a report that provides details on individual units it has a column that lets you know if that unit is rental or unrentable. it uses binary to illustrate this:
- bRentable
- 0 = “Unrentable” or “Offline”
- 1 = Rentable
How can I write something in the analyzer that I can use as a filter that will replace 0 with Unrentable and 1 with Rentable?
0
Answers
-
bRentable is the column name*
0 -
In the analyzer click on "Add Calculated Field" in the bottom left and write the following formula:
CASE WHEN 'bRentable' = 0 THEN 'Unrentable'
WHEN 'bRentable' = 1 THEN 'Rentable'
ELSE 'Unknown'
END
I used the else clause in case you have empty or null values and didn't want to assume it was rentable or not.
2
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 337 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 83 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有