small()

Hi,

I have the following sample of information of 2 cities, Miami and Boston, both from the USA:

My KPI works the following way, we can calculate it at a City level (Miami/Boston) or at a country level (USA) so...

For the USA

First, if we are measuring the time of reaction of the country USA we have a total of 20 movements right? (one per row)

Then we rank the time of reaction of those movements from 1 to 20

Then we calculate the 90% of 20 = 18

So finally the value of the KPI for USA is the time of reaction at the 18th position of our rank, in this case is 98 minutes

On the other hand for Boston (for example)

First, if we are measuring the time of reaction of the city Boston we have a total of 10 movements

Then we rank the time of reaction of those movements from 1 to 10

Then we calculate the 90% of 10 = 9

So finally the value of the KPI for USA is the time of reaction at the 9th, in this other case is 80 minutes

If we reply the excercise for Miami, the KPI is 98 minutes.

Sorry, if its hard to get, my english is not very good.

Kind regards