Joined: 05 Feb 2009
Online Status: Offline
Posts: 3
Topic: Exclude top 10% and bottom 10% Posted: 07 Jun 2010 at 5:15am
I have a report which details the time it took to close incidents in the ServiceDesk system, with a row for each incident. I have created an average for the time to close but now I have to exclude the top 10% and bottom 10% from the calculation so only the middle 80% are evaluated. I can't see how this can be achieved using Top N and the only answer I can think of is to manually calculate the middle 80% and then put the relevant figures into the report selection. Unfortunately this report will be run on demand by the team management, so that's not really a solution.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum