Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
stalwar1s@@@@@who knows what the now function used below in my expression will produce??
IF(TICKET_STATUS = 'WORK IN PROGRESS' OR TICKET_STATUS='HOLD' OR TICKET_STATUS='ASSIGNED' OR TICKET_STATUS='NEW',
IF(TIER='GOLD' AND NOW()>RESOLVE_BEFORE,'OUT_OF_SLA','IN_SLA'),
IF(TIER='SILVER',
IF(DECODE_PRIORITY ='High' AND (NOW()+2)>RESOLVE_BEFORE,'OUT_OF_SLA',
IF(DECODE_PRIORITY='Medium' AND (NOW()+7)>RESOLVE_BEFORE,'OUT_OF_SLA',
IF(DECODE_PRIORITY='Low' AND (NOW()+10)>RESOLVE_BEFORE,'OUT_OF_SLA','IN_SLA')))))
I want the number(2) in (NOW()+2) to be in DAYs and not HOURS??
e.g NOW()+2DAYS
Yes. Thanks Ever so much.
Count({<REMEDY_SLA_MET>}[TICKET_ID_])/Count({<SLA, REMEDY_SLA_MET>}TICKET_ID_)
I wanna learn, what does that line do??
Numerator ignores selection in REMEDY_SLA_MET and Denominator is ignoring selection in both SLA and REMEDY_SLA_MET
Thanks ever so Much Sunny. u' amazing!!