You know, there are some days where I'd like to feel self sufficient and be able to go it alone without having to come to the community for help...
today is not that day
Have a question for you all!
I've been following Richard and Johnathan's different guides on dealing with this issue of Quantiles and ranking. For the most part i've been able to follow along and have been able to get results of the bottom 33% (third) for different measures. Now what I'm hoping to do is to look for bottom performers across time and measure criteria
(Using Superstore data)
What I did was create three worksheets that would rank Customer's order's based on three measures (QTY, Profit, Unit Price)
I then filtered each worksheet to only show the bottom 33% of orders
I placed these three worksheets on a dashboard
Created a "dummy summary sheet" and placed it in the dashboard as well.
This is where I got stuck
What I'm hoping to do, is to create a calculation that goes through the results of each worksheet and find if there are order numbers that appear in the bottom 3rd of at least two measures over two consecutive quaters and then display it in my summary sheet.
Granted the super store data and this question aren't very logical, primarily I'm looking to figure out some sort of performance dashboard where my product providers score in the bottom third consecutively over time and in x number of measures to have it show up in my summary so I can address it. Is this even possible?
In my head I envision a function/calculation that counts (in the super store example) the if the order number appears in 2009 Q1 in each worksheet and some sort of case statement where if the count is = 2 then show in Sheet 4? Where I get stuck is how to iterate across worksheets (Or if I even can)
I've included a superstore TWBX as an example. Would appreciate any help the community can lend! Or even a better way to do this
Performance Ranking.twbx.zip 1.2 MB