Beastmode suggestion for a filter

Golfoholic · 2021-07-22T21:51:37+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Analyzer

Filters

Accepted answers

All comments

Golfoholic

bRentable is the column name*

MarkSnodgrass

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of