Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

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