Beastmode suggestion for a filter

Golfoholic
Golfoholic
in Charting

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?

Tagged:

Answers

  • Golfoholic
    Golfoholic

    bRentable is the column name*

  • MarkSnodgrass
    MarkSnodgrass Coach

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories