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

Best Answer

  • ilikenno
    ilikenno

    domo

    💎

    Accepted Answer

    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 [email protected] 



Answers

  •  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 

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

  • this is great -bIG tHANKS 

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

     

  • 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

  • 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