Need a Query For Calculating Mean time to resolve by month

[gmanju]

Need a Query For Calculating Mean time to resolve by month

[darius_koohmare · Accepted solution]

here is one example of a report that can indicate if your monthly resolve time is increasing or decreasing.

This simple example still maintains the units of data that the duration field stores in, which is why you see the large decimal values.

[rdharr4]

Any way ServiceNow will convert the seconds to hours so the user does not have to make the calculation?