Creating report

[mohammeda36]

I need to create a report for problem metric to find the actual average of each state  moving from one state to another and need the current state as well. 

[Dr Atul G- LNG]

Add here

[Ankur Bawiskar]

@mohammeda36 

you can create metric definition similar to Incident State and do this for Problem State field

also check this link

Average time by state 

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

[mohammeda36]

Yes, i follow! But can you please tell me what filter needs to be applied. Table that i uses is - problem_metric.

[Ankur Bawiskar]

@mohammeda36 

yes that's correct

To show current problem state -> add the "State" field from the Problem table to your report so you can see the current state alongside the historical transition averages

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

[mohammeda36]

I need help creating a PA dashboard that shows average resolution time per Problem record (not grouped by date). The bar chart should list each Problem record individually and allow drill-down to see which state took the longest. Any guidance on which indicator/breakdown setup is required?

I would like the dashboard to have a similar layout to the snippet below. However, instead of displaying dates, it should show problem records, and instead of numbers on each bar, it should reflect the number of days.