create a report based on incident priority change

[Gaurav Vaze]

I want to create a report, that will show the incident based on priority change
I have created the Metric definition for the priority field
and also created a report which is on the Incident_metric table and the definition is one that I mentioned earlier.
However, this report does not take into account the previous incidents
I want it to show only those incidents whose priority has changed in the last 3 months
adding SS of the created definition and  report

Help will be appreciated 
Thank you in advance

[Gaurav Vaze]

Thanks,
Now, I'm looking for a way to fetch only those records for which the priority is actually changed
here is what I'm looking for:
current metric definition also creates the metric instance record for newly created incidents as their priority is set initially
however, I only want those records for which the initial priority is CHANGED
what can I do?
what script needs to be added?
help will be appriciated

[Gaurav Vaze · Accepted solution]

I have found a workaround for the question I posted
please follow following steps to get the report

step A] create a metric definition on the priority field

• Navigate to Metric definitions (metric_definition)
  
  
• click on new
• choose a table as Incident
• choose type as field value duration
• choose field as Priority
  
  

step B] Create a script include to get the unique records having the priority actually changed

• under system definition, navigate to script include and click on new
• give the appropriate name and paste the following code(note the name of SI will be different  in your case)
  
  
• save

step C] Create a report on the incident_metric table

• navigate to create a new inside report
• give title, choose table as incident_metric
• choose type as list
• choose filter as: definition is [your definition name create din first step] and sys_id(inc_sysid) is one of the 
  javascript: new (your Si name here followed with ()).(your function name inside SI followed with ())
  (example: javascript:new ICgetMetricInstances().createMetric();)
  
  
  Note: this will give you those incidents for which priority is changed actually