9 Replies Latest reply: Apr 25, 2017 7:44 PM by Henry Esparza RSS

    set analysis count field =today()-30

    Monica Labrador

      I am trying to find out how many "open" tickets there were 30 days ago from todays date based on "date_opened," I am receiving an error with the below set analysis, I think it has to do with the "today-30" section, I've also tried today()-30.

       

      Any help is much appreciated.

       

      count({<date_opened={"today-30"}>}case_number)