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]

Please create a Database view similar to the one given in the screenshot below,

Please update the Where clause on table metric_defintion table to md_sys_id = <sys_id_of_your_metrc_definition_record>

Once done create a report from this Database view.

[Karthik Reddy11]

Hi Vasanth

Instance upgrade was done for last 10days sorry to reply late

I have created a database view when i click on try it  it is showing some error

please check below image

and also 

Metric definition

Metric Instance

Instance

and How to create report from database view?

I have created direct reports and i have given filter like definition =Track severity changes(Metric definition Name)

is this correct?

can you help me with this 

[Vasantharajan N]

Hi Karthik,

Please give the sys_id within double quote and try.

[Karthik Reddy11]

Hi Vasanth

what are the fields I have to added on

1)Metric Definition

2)Metric Instance

3)Incident

can you check where clause on above images in last chat

it is showing error 

[Vasantharajan N]

If you added any specific field in the table, Please make sure the you added definition field from metric_instance table.