Skip to content

    • Beast Mode

    Beast Mode

    Can someone tell me where I am going wrong please?

    Member
    in Beast Mode

    CASE
    WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())
    WHEN 'metric'='PREV MONTH' THEN CONCAT(MONTH(NOW())-1,'-',YEAR(NOW()))
    WHEN 'metric'= 'THIS MONTH PREV YEAR' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())-1)
    ELSE ''
    END

    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

    Best Answers

    • Coach
      Answer ✓

      I think you could make this easier by using the DATE_FORMAT() function along with DATE_SUB().

      CURRENT MONTH 

      1. DATE_FORMAT(NOW(),'%M %Y')

      Would return February 2024

      PREV MONTH

      1. DATE_FORMAT(DATE_SUB(NOW(), interval 1 month),'%M %Y')

      Would return January 2024

      CUR MONTH PREV YEAR

      1. DATE_FORMAT(DATE_SUB(NOW(), interval 1 year),'%M %Y')

      Would return January 2023

      **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.
    • Member
      Answer ✓

      This helped! Thank you

    Answers

    • Coach

      Without having more information about what your issue is I'm assuming it's dealing with your prev month where it's subtracting a month.

      You want to make sure you subtract a month from your date before getting the month and year for it.

      1. CASE
      2. WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())
      3. WHEN 'metric'='PREV MONTH' THEN CONCAT(MONTH(NOW() - INTERVAL 1 MONTH),'-',YEAR(NOW()-INTERVAL 1 MONTH))
      4. WHEN 'metric'= 'THIS MONTH PREV YEAR' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())-1)
      5. ELSE ''
      6. END
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      I have a beast mode, 'metric', in this case that essentially has the current month, previous month and this month previous year stored in it. 'Metric' is a beast mode I created using a date column. My objective in this beast mode is to essentially change the name from current month to the name of the actually month and what year.

      For instance right now curr month should return February 2024 and prev month should return January 2024. I want this to be dynamic.

      The solution you sent didn't work for some reason

    • Coach
      Answer ✓

      I think you could make this easier by using the DATE_FORMAT() function along with DATE_SUB().

      CURRENT MONTH 

      1. DATE_FORMAT(NOW(),'%M %Y')

      Would return February 2024

      PREV MONTH

      1. DATE_FORMAT(DATE_SUB(NOW(), interval 1 month),'%M %Y')

      Would return January 2024

      CUR MONTH PREV YEAR

      1. DATE_FORMAT(DATE_SUB(NOW(), interval 1 year),'%M %Y')

      Would return January 2023

      **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.
    • Member
      Answer ✓

      This helped! Thank you

    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