Create report on SLA

Vishal40
Tera Contributor

Hello Developers,

I wanted to create a bar chart report which will show " Number of tickets in Priority 1 , Priority 2 , Priority 3...based on SLA Achieved and SLA Breached. Screenshot attached.

e.g. SLA Achieved Priority 1 tickets are 10 , SLA Breached Priority 1 Tickets are 2

SLA Achieved Priority 2 tickets are 7 , SLA Breached Priority 2 Tickets are 1

SLA Achieved Priority 3 tickets are 11 , SLA Breached Priority 2 Tickets are 3....

Kindly help me with your expert advice. Thanks In Advance.

 

 

1 ACCEPTED SOLUTION

Hi @Vishal ,

 

You can change the label of Y-axis like below:-

find_real_file.png

You can't directly change the true/false to any other label. But there is one workaround you can create 2 custom fields on task SLA and change their values as per has breached field and use that fields in the report like below:- You can write BR for that

On Before Insert and Update  


if(current.has_breached=='true'){   //verify backend name for breached.
current.u_has_breached_string="SLA Breached"; //set custom field value based on has breached field.

}
else{
current.u_has_breached_string="SLA Achived";  // Custom field
}
}  

 

 

Please mark my answer as helpful/correct if it resolves your query.

 

Regards,

Gunjan Kiratkar

Consultant - ServiceNow, Cloudaction

Rising Star 2022

 

 

 

 


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

View solution in original post

6 REPLIES 6

Gunjan Kiratkar
Kilo Patron
Kilo Patron

Hi @Vishal ,

My Report Output:-

find_real_file.png

 

I have created this report on the 'task_sla' table.

true= SLA breached.

false= SLA achieved.

It has a group by task.priority and has breached as per your requirement.

find_real_file.png

Please take a look.

 

Please mark my answer as helpful/correct if it resolves your query.

 

Regards,

Gunjan Kiratkar

Consultant - ServiceNow, Cloudaction

Rising Star 2022

 


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

Just add one filter like below for incident-only tasks.

find_real_file.png

 

Please mark my answer as helpful/correct if it resolves your query.

 

Regards,

Gunjan Kiratkar

Consultant - ServiceNow, Cloudaction

Rising Star 2022

 


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

 

 

 

 

 

 

 

 

 

 

 

hi Gunjan,

if i want to display of 25% red, 75% green, how can customise color length

Vishal40
Tera Contributor

Thank you, Gunjan for your prompt reply. Please let me know how can I change false & true with "Achieved and Breached" labels and Task SLA count with " Number of Incidents"?