User Profile
JGARIN
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Re: 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 regardsRanking and selecting by positions
Hi, I have the following problem. I have a sample of merchandise movements between different stores and the time (in minutes) that took those movements (reaction time), this is due to higher demand than planned so we have to move inventory between stores. So, one of my KPI is the reaction time that covers the 90% of my movements. So technically I have to rank all of my movements in a given period of time, and select the one that covers the 90% of them. This KPI is measured by city, state and per country so the ranking has to be dinamic so the indicator has to recalculate depending of what you are looking. Kind Regardssmall()
Hi, I have the following problem. I have a sample of merchandise movements between different stores and the time (in minutes) that took those movements (reaction time), this is due to higher demand than planned so we have to move inventory between stores. So, one of my KPI is the reaction time that covers the 90% of my movements. So technically I have to rank all of my movements in a given period of time, and select the one that covers the 90% of them. This KPI is measured by city, state and per country so the ranking has to be dinamic so the indicator has to recalculate depending of what you are looking. Kind Regards
