Metric report to track the severity changes to any incident ticket

[Karthik Reddy11]

Hi all

How to Create a metric report to track the severity changes to any incident ticket

If severity changes on incident ticket it should track all records and total count how many times severity changes

Ex:

On Incident ticket the severity is 3 and if changed to severity 2 and then changed to 1 again 

Then it will show all 3 changes and total count of incident severity changes 

I didn't worked on Metrics till now can you help me with this 

Regards,

karthik

[Vasantharajan N]

• You can create metric definition (All > Metrics > Definitions) for priority change on the incident table.
• Create database view between incident, metric definition and metric instance table
• Create pivot table type reports (select incident number for Column, priority for Row)

[Karthik Reddy11]

Hi Vasanth

It is not showing the previous changes severity

ex:INC0267513 i have changed 5 times from low-critical-low-moderate-High

then it showing 5 count in table 

so i want to display previous severity for that incident 

[Vasantharajan N]

Please use value field data from metric instance table to get the required report. 

Report :- 

Data:-

Still if you have the problem, Please post your metric definition and database view to help you further.

[Karthik Reddy11]

Hi

Database view:

Database view:

Metric definition:

Report:

Report2: