creating Report for Metric Major Problem

[mohammeda36]

I need to create a report for Metric for Major Problems to calculate the average time to move from one state to another state of the problem until resolved state

[SumanthDosapati · Accepted solution]

@mohammeda36

OOB there is already a 'Problem State Duration' Metric in ServiceNow.

Navigate to metric_instance table and filter with Definition is 'Problem State Duration'

You can see the start, end, value columns storing details.

Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth

[mohammeda36]

Thanks @SumanthDosapatiSumanthDosapati. 

One more question- In the bar chart for the metric instance table, can we show the value/ count on top of each bar? For Example, how many are open for more than 30 days and their current state. Is this configurable?

[SumanthDosapati]

Exactly same UI which you asked might not be possible.