Incident priority upgraded report

Shinim
Tera Contributor

Hi … I’m trying to create a report that shows only those incidents which were upgraded to Priority 3 (P3) from P4 or P5, and the upgrade happened yesterday.

 

I’m using the metric_incident DB view to track priority changes. Used below conditions 

 

  • The incident creation time differs from the metric record creation time and priority change on previous day. 
  • My current query brings in all P3 incidents, including those degraded from P2 to P3 — but I want to exclude those and include only upgrades from P4 or P5.                                          Has anyone tackled this before? How can I accurately filter the dataset to show only the incidents upgraded to P3 from P4/P5 on the previous day?

 

Thanks in advance!

0 REPLIES 0