How to puall a report of tickets once 75% of SLA is breched

[shaik_irfan]

Hello,

I need to pull a report of tickets which are about to breach and 75% of SLA time completed

[Preetam Barai]

HI Shaik,

You can do a report on task_sla table and use the below query.

task.numberSTARTSWITHINC^business_percentage>75.

Hope this helps.

[Obul]

while defining indicators give the condition Actual elapsed percentage between 75 and 99 and you will get the records which are above 75% of time completed and about to breach. Please mark as helpful if it helped you. Thank you Obul

[AbdulAzeez · Accepted solution]

Hello Irfan,

Create a report of Task_SLA / Incident_SLa table and in the condition you can filter Business Elapsed PErcentage is greathan than 75

With this you filter the tickets whcih are about to breached and 75% sla time is completed

[Priya Singh3]

Hi,

What filter I should put if I want to fetch data for today :

Like : Incidents whose elapse percentage is 75% or more than 75% today