Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
efowler
Helper II
Helper II

Best method to visually show "Case file resolution" time

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? Case file time to resolution.jpg

1 ACCEPTED SOLUTION
rsbin
Super User
Super User

@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,

View solution in original post

3 REPLIES 3
rsbin
Super User
Super User

@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,

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.. 

@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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.