Incident Report that captures severity changes

JLeong
Mega Sage

Hi Guys,

How can I create an Incident report that captures the changes in severity? Example: Ticket#123 was initially created as sev3 and was moved to sev2 or sev1 and vice versa. The report should show the number of incidents where severity was changed and how many times it was changed.

Note: We don't have Performance Analytic activated.

Thanks in advance.

Regards,

Jocelyn

1 ACCEPTED SOLUTION

gyedwab
Mega Guru

Hello Jocelyn,



Take a look at Metrics Definition:


http://wiki.servicenow.com/index.php?title=Metric_Definition_Support#gsc.tab=0



Metrics allow you to track how long a field is in a particular state, and how many times it changes along the way.



Then, you can report on the Incident Metric table on those changes using the out-of-box reporting engine.



If you want to get a slightly more advanced report, you can use Explore Analytics to do some calculations.



Here's a live report I created to show what % of incidents had their severity changed at least once:


Screenshot 2017-09-14 12.01.26.png



And then I right clicked on the % unchanged cell to create a scorecard:


Screenshot 2017-09-14 12.04.19.png


Screenshot 2017-09-14 12.04.04.png


The scorecard above will now track that metric on a schedule so we can see if we're improving or not improving.


View solution in original post

2 REPLIES 2

gyedwab
Mega Guru

Hello Jocelyn,



Take a look at Metrics Definition:


http://wiki.servicenow.com/index.php?title=Metric_Definition_Support#gsc.tab=0



Metrics allow you to track how long a field is in a particular state, and how many times it changes along the way.



Then, you can report on the Incident Metric table on those changes using the out-of-box reporting engine.



If you want to get a slightly more advanced report, you can use Explore Analytics to do some calculations.



Here's a live report I created to show what % of incidents had their severity changed at least once:


Screenshot 2017-09-14 12.01.26.png



And then I right clicked on the % unchanged cell to create a scorecard:


Screenshot 2017-09-14 12.04.19.png


Screenshot 2017-09-14 12.04.04.png


The scorecard above will now track that metric on a schedule so we can see if we're improving or not improving.


Thanks so much Guy! I will the Metric for now.