How do we get a report to find the SLA that didn't Breach ( never Response not Resoultion)

[MSM1]

Hello Team,

Need a help in generating a SLA Report. I wanted to find number incidents never breached the SLA.

we have 2 SLA one is for Response and the other is Resolution. If one among them is breached, then it is a breached ticket. 

I tried to filter from Task_SLA table here I am querying with my specific filters(SLA Name) and group by task. I would get something like this below: how .do I put some logic or a condition to see "Has Breached" is false for both the entries on the incident record.

Please suggest.!

Thanks!

[Chetan Mahajan]

Hi,

     Try to run report on incident_sla table where you can use has_breached field as condition.

Kindly mark correct/helpful if it works for you

[MSM1]

Hello Chetan,

Thanks for the response!

So if we run a report on incident SLA, with some has Breached condition. I may get the SLA Level whether the SLA is breached or not, from the above screen shot, I will see the record "INC0292157" which actually breached on of SLAs and that will not serve my requirement.

I tried some filter query but unable to get the logic here, I queried the Task_SLA table and grouped by task number and then I failed to get the records where record is having Has Breached as "False".

Any suggestions on this please.

Thanks,

smitha. 

[Fathima1]

Table name : incident_sla

Group by : Has Breached and pie chart with true and false will give the picture of Breached vs Non Breached. Here is the snapshot

[Sumit Hastu1]

i have a same requirement where i have to highlight has breached true and false incidents in a report i am achieving through PA have created indicator and indicator source now in breakdown source as has breached is boolean type field what fact table and field should i select in breakdown source.