4 Replies Latest reply: Nov 12, 2014 3:23 PM by Shannon Lepore RSS

    Need to add max date in expression

      Hi,

       

      I am trying to write an expression for a chart that will show the total number of work orders for a specific department.  I also need to provide this by the max OPEN_DATE.  Basically I need to show the most recent data.

       

      I’ve got this so far:

       

      sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'}>} COUNT_TICKETS)

       

      But I’m unclear on how to incorporate the max OPEN_DATE in to my expression. 

       

      Any help or guidance would be greatly appreciated.