Interval()

[#1]

  Hi All,

I want the correct count of Incident Nos. which have SLA_RESPONSE_TIME in hours beyond what is passed on to variable. But I am not getting exact count of Incident Nos.Logic:

Count

(distinct INCIDENT_NO)-Count(distinct if(Interval((Interval#(SLA_RESPONSE_TIME,'ddd:hh:mm:ss')),'hh')<=$(vResponsePendingHours), INCIDENT_NO))

Any help would be appreciated. 

Thanks in advance!!

Regards,

Ankita.

[tresesco]

Can you please share a sample app?

[sudeepkm]

You may try to flag those Incidents which has crossed the SLA Response time in the script.

For example:

1. declare a variable to hold the threshold hour for e.g. vThrshold=10;

2. load

if([SLA Response time] >= '$(vThrshold)',1,0) as SLAFlag // you can use TimeStamp([SLA Response Time],'HH:mm:ss') for hours

3. in your chart expression you can use like below

count({<SLAFlag={1}>}IncidentID)