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

    Need to add max date in expression



      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.