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!
