Want to create report in which Prioroity upgrades, State changes visible

[SHUBHAM78]

I need all the a report for incident data for Moderate and High Priority Incidents (Priroity levels - 1 2 and 3)
that are Resolved for some queues.

The data I am interested is the field changes e.g. Prioroity upgrades, State changes etc. the Incident[Incident] table only provides Comments and work notes.

we can't use sys_audit table and sys_history_line and sys_journal_field are not reportable in the report.

I have created Metric Definition(metric_definition) for state, assignment group, priority, assigned to. Now I want to create report. How can I proceed further and create report with the above details 

[Mark Manders]

What's not working? Because you already gave the answer: your metric instance table has the changes you are looking for, so that's where your data is. You need to report on those tables.

[Dr Atul G- LNG]

Hi @SHUBHAM78 

Currently, you have three metrics. Do you want to combine these three metrics into one, or keep them separate? If you combine them, it will require a database view, but I’m not sure we can get everything correctly that way. It’s better to create three separate database views:

• Metric 1 with Incident

• Metric 2 with Incident

• Metric 3 with Incident

Then, use these database views to create the report.

[Ankur Bawiskar]

@SHUBHAM78 

already incident_metric database view is available and you can use that in report

It will show you State Changes

Simply create metric definition for Priority and then it will start coming in that database view as well

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@SHUBHAM78 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏