Skip to content

    • Archive

    Archive

    Beast Mode Calculation for cutting off the last months

    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:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • 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!! 

    • Domo Employee

      Sorry about that.  Good catch

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories