Beast Mode Code

I am trying to write the following Beast mode code

If a date field is blank then "CAPA Phase" else it is "Implementation Phase " the following case statement will not work

case when `PA_PLAN_DUE_DATE`='' then 'CAPA Phase' else 'Implementation Phase' end

Find more posts tagged with

Accepted answers

Gimli

Hello,
In order to call upon NULL values in a beastmode you refer to them using the key word NULL.

For example:

CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END

If this does not fix the issue you are experiencing you can email our great support team at support@domo.com.

All comments

HelenOBrien

how do I work with null dates in DOMO (Beast Mode)

I need to say if date is null then x else y

please help

Gimli

Hello,
In order to call upon NULL values in a beastmode you refer to them using the key word NULL.

For example:

CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END

If this does not fix the issue you are experiencing you can email our great support team at support@domo.com.

kshah008

@HelenOBrien, did ilikenno's reply help you out?

HelenOBrien

this is great -bIG tHANKS

CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END

user03674

I'm trying to add another command in this statement, but it isn't working. does elseif not work?

Case
When
`ACTUAL_START_DATE` is null then 'Tracking'
elseif 'ACTUAL_START_DATE' is not null and `ACTUAL_END_DATE` is null then 'In Process'
else 'Completed'
End

BlueRooster

Case
When
`ACTUAL_START_DATE` is null then 'Tracking'
WHEN 'ACTUAL_START_DATE' is not null and `ACTUAL_END_DATE` is null then 'In Process'
else 'Completed'
End

Just change elseif to WHEN instead

That should work for you,

Valiant