2 Replies Latest reply: Jun 22, 2016 11:41 AM by Sunny Talwar RSS

    Set Analysis in Expression to show open tickets 60 days or greater

    Linsey Kempton

      Hello,

      I want to create an expression showing my open tickets that have been open for greater than or equal to 60 days.
      My Date field is Date_Created. With the following expression my result comes back as '0'

       

       

      =Count({<Date_Created={">=$(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)