- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2022 09:27 PM
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.
Solved! Go to Solution.
- Labels:
-
Analytics and Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2022 11:46 PM
Hi
You can change the label of Y-axis like below:-
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2022 09:58 PM
Hi
My Report Output:-
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.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2022 10:04 PM
Just add one filter like below for incident-only tasks.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2024 09:21 AM
hi Gunjan,
if i want to display of 25% red, 75% green, how can customise color length
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2022 10:54 PM
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"?