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

[JagjeetSingh]

For that you have to select different visualization. In Type section, select Type from Time series.

In next screen you can select "month" in Per field.

Mark it helpful or correct if it worked for you.

[JagjeetSingh]

@rsharma - Hey! Did I solve your query. Let me know if you need further help around this.

[JagjeetSingh]

You are on right track. Just try to change the value in field "Per" under "Trend By". Change it to a week or days. You'll have your line graph for one month.

If you want to see the data month wise, then you have to include the previous months as well. For this change the filter condition "Created" on "Last month" to Created on this quarter or this year.

Mark my answer correct or helpful if it is worth it.

[Andrew_TND]

In my opinion I wouldn't use the task_sla table as the incident table has a resolved field which time stamps the resolution date/time. But if you want to encorporate incidents into it you could always dot walk it.

See my example below on how I would do it.

Time series

Obviously this is simplified but you could make it as complex as you'd like.

Please mark as helpful or if its resolved the issue, correct!

[Andrew_TND]

If you wanted SLA data in there you could add this via report structures, see my blog below,

Report Structures

Please mark as helpful or if its resolved the issue, correct!