Best method to visually show "Case file resolution" time

[efowler]

Hello,

I have built a report for a call center to track case files time to resolution (created date/time - Resolved date/time).  I am having some trouble visually displaying this because there is such a wide range of time to resolution.   Specfically there are signific cases in which the case file is resolved in less than 1 hour and there are some that are resolved in hundreads of hours.  This creates an issue for displaying "average' time to resolution. 

Any ideas on how to better display a visual in this situation?   Is there a way to exclude the top 20% and bottom 20% in the calculation to trim off the cases that remain open extremely long times or that are closed in less than X minutes? 

[rsbin · Accepted solution]

@efowler,

There are a number of ways you can down this "statistics" rabbit hole.

Median may be a better measure than average when you have a wide variance. 

A custom "Box and Whisker" visual is one that I have used as well when I encounter a situation such as yours.

Yes, I'm sure there is a way to exclude "outliers", but someone with more expertise will have to help you with that.

Hope this helps.

Regards,

[efowler]

Thanks for the suggestion on the Box and Whiskers visual.... I am going to use that for now. 

It would be nice to be able to overlay a KPI/Target into the Box and Whiskers visual.. 

[rsbin]

@efowler,

You can try to add your KPI to the Tooltips, or create your own custom Tooltip page.

Lots of videos on the subject....have at it.

Regards,

P.S.  Please give Kudos if you like a response provided to you.  Thx.