Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

JGARIN

Ranking and selecting by positions

Submitted by on ‎03-08-2019 07:27 AM

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

Status: New
Comment