Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try and write like
sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'},
OPEN_DATE = {'$(=Max( OPEN_DATE ))'} >}COUNT_TICKETS)
Regards
Anand
Try and write like
sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'},
OPEN_DATE = {'$(=Max( OPEN_DATE ))'} >}COUNT_TICKETS)
Regards
Anand
Use Date format of OPEN_DATE in this expression
sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'}, OPEN_DATE = {'$(=Date(Max( OPEN_DATE )),'MM/DD/YYYY')'}>} COUNT_TICKETS)
Hi,
add this to your code.
OPEN_DATE = {"$(=Max( OPEN_DATE ))"}
Try like this
sum({<[Department]={'Development Services'}, [Work Order Status]={'Pending','Overdue'},
OPEN_DATE = {"$(=Max( OPEN_DATE ))"} >}COUNT_TICKETS)
Regards
ASHFAQ
Thanks you for your response - this worked!