Expand my Community achievements bar.

Come join us for our Coffee Break next week on top takeaways from Adobe Summit!

Calculating average turn-time for Issues plus exclusions

Avatar

Level 4

Hello - I'm wondering if anyone has done this. We have a report where we're pulling the average turnaround time for issues but we want to exclude some outliers that are skewing the numbers (requests that took much longer than they should have and we want to remove from the report). We built a custom field and used this calculation to allow us to ignore those that have higher than 20 days turn-around time:

 

IF(WEEKDAYDIFF({entryDate},{actualCompletionDate})>20,"FALSE",WEEKDAYDIFF({entryDate},{actualCompletionDate}))

 

Then we filtered on that field in the report. This works but we're being asked if we can just exclude by a percentage instead such as 5%. 

 

Is there a way to do an average and then exclude a certain percentage, Perhaps build off standard deviations or criteria? Any thoughts would be welcomed. Thanks!

 

0 Replies