Trending - Incident Resolution Time over a month

[dbenjile1]

Hi team,

Without using Performance Analytics, i'm trying to create a line graph, which shows the average "Incident Resolution Time" per Incident across.. lets say... the previous month.

This is what I put together so far..

I am not quite sure which fields to use at the moment, and was wondering whether the experts here can help.

My thanks, Dave

[Slawek_Radziewi]

It is correct. Just add more time like last 3,6 month etc. so it can show line through time (trend).

[rsharma]

Hi Slawek, 
Is there any way we can see the resolution time for diffrent assignment group ?

[JagjeetSingh]

Yes, it is possible with normal reporting in Starting Quebec. You can choose the Configure function field option and use function datediff(resolve date, created date).

Mark my answer helpful or correct if it helped you.

[rsharma]

Hi Jagjeet,

Apreciate your response , I have created a function field like below and table I am using is Incident table because I dont see Assignment group filed on SLA table .

I am getting the graph but how can i get data of previous months to compare.

I need to compare the Incident resolution time for last 3 months and for different teams.