Connectors

Connectors

30 day running date alert

Hello,

 

I'm trying to create a date range that will be continual, comparing today to 30 days ago. I have a feeling it's somewhere within creating a calculated field, but I don't know what the formula would be. My idea would be to have a specfic filter that would include date(today, today - 30days) but the actual process is unknown to me. I would only need those two dates to do a percent difference alert for different variables. 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

Best Answer

  • Domo Employee
    Answer ✓

    No worries, you just need to change my formula to fit your field names:

     

    I used `Date` because I did not know what you called your date field.  

     

    Change it to `Your Date Field Name` and it should work

Answers

  • Domo Employee

    You can accomplish this by creating a beast mode calculation and then using that calculation as a filter

     

    case

    when `Date` = CURDATE() THEN 'true'

    when `Date` = DATE_SUB(CURDATE(), INTERVAL 30 DAY) THEN 'true'

    else 'false'

    end

    • @ST_-Superman-_ I appreciate the help! Unfortunately, I'm recieving the " Invalid Formula : A column in this calculation did not exist." error when I try to evaluate the formula you included in your comment. Should I be doing more than just "adding a calculated field"? I've added a screenshot to hopefully clarify what I'm doing wrong. Domo Question.PNGSorry I'm terribly new to this program. Thanks again!
  • Domo Employee
    Answer ✓

    No worries, you just need to change my formula to fit your field names:

     

    I used `Date` because I did not know what you called your date field.  

     

    Change it to `Your Date Field Name` and it should work

  • killer thanks so much!

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