Forum Discussion

JGARIN's avatar
JGARIN
Frequent Visitor
7 years ago

small()

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

5 Replies

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    Hi,

     

    It is unclear what is your issue. Could you please provide some screens with more deep explanation?

     

    Thanks!

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

    • JGARIN's avatar
      JGARIN
      Frequent Visitor
      7 years ago

      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

      • v-evelk's avatar
        v-evelk
        Microsoft Employee
        7 years ago

        So, do you want to create a new visual to show this calculation or you look for an existing visual that can cover this?

         

        Evgenii Elkin,
        Software Engineer
        Microsoft Power BI Custom Visuals
        [email protected]