Beast Mode Calculation for cutting off the last months

user02485
user02485 Member
in Archive

Hi all,

I have a question on how to create basically a Beast mode tyle filter that will cut off the last 3 months. 

 

my datecolumn is in the MM/DD/YYYY format (4/26/2018).  So I would like to take the most recently closed month (end of March) and subtract it by 3 months to only report data up to 12/31/2017.   

 

Thanks for your help.  

 

Tagged:

Comments

  • ST_Superman
    ST_Superman Domo Employee

    You could try this.  Using this field as a filter and select 'true' to show only dates you are looking for.

     

    case 

    when year(`datecolumn`) <= year(date_sub(curdate(), interval 4 month)) and month(`datecolumn`) <= month(date_sub(curdate(), interval 4 month)) 

    then 'true'

    else 'false'

    end

  • Unknown
    Unknown

    Thanks for the response, I got a syntax error though.  Maybe it needs added parantheses somewhere? 

  • Unknown
    Unknown

    I realized it's missing "interval" and it was able to validate.  

     

    Thanks!! 

  • ST_Superman
    ST_Superman Domo Employee

    Sorry about that.  Good catch

Categories