Best way to find average resolve time for incidents as per priority?

[Snehal13]

I am running report on task_sla table to get average resolve time of incidents per week for a specific assignment group. 

Conditions are Task Assigned group =<Assignment group name> AND Task type = Incident AND Task last updated on last week AND Task state resolved and grouped by Priority

Is this the best way to look upon the resolve time per week on incidents by priority ? Any other alternatives for the appropriate numbers ?

[Dr Atul G- LNG]

Hi @Snehal13 

You can try this way

create a score type report on Incident table. 

[Snehal13]

Ok Atul but I need the average incident resolve time per priority for each week in Hours/Minutes/Days

[Dr Atul G- LNG]

Hi @Snehal13 

Then it is not possible in standard reporting. You can use Performance Analytics and then put the indicators for same.

[AndersBGS]

Hi @Snehal13 ,

Just utilize a bar chart with below configuration:

This will give you below result:

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders