In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Rank in Alteryx

rjesus1987
6 - Meteoroid

Hello Team,

 

I'm trying to rank the performance score of each employee based on their department to identify if they belong to Top 30%, Mid 40% & Bottom 30%.  See sample table below.

 

NameDeptScoreRanking
JohnAB2 
MikeBC4 
KarenAB5 
DaveBC2 
DawnBC10 
JacobBC8 
RyanAB6 
SelenaAB7 
AileenAB3 
JeremyBC4 
SteveBC8 

 

 

5 REPLIES 5
alexnajm
18 - Pollux
18 - Pollux

I would look at the tile tool -using the unique value option, selecting department as your grouping, and sorting on score

OTrieger
13 - Pulsar

Another way will be to use the Multi-Field Binning. The advantage here that you can define the amount of Bins - Ranking levels that you need.

alexnajm
18 - Pollux
18 - Pollux

I would disagree with this based on the requirement of splitting by department - the Multi-Field Binning will only be tiling based on numeric fields. I think the Tile tool would be the safer option! However, happy to be wrong so would love an explanation

OTrieger
13 - Pulsar

The splitting of the different departments can be done in several ways, and as the Score is numeric there should not be an issue, the Binning solution gives a more accurate ranking than the tile solution, as you can select to how many groups you would like to get. So you can get 3 ranking levels, 4, 5 or how many you will select. If I recall correctly, you cannot set the Tile tool to select if you will get 3 levels, 5 levels and etc.

So none of the solutions is perfect, additional tools will be needed to get the final desired result.

alexnajm
18 - Pollux
18 - Pollux

I still disagree and would love to see more of your thought process on how to get the rankings off of the Multi-Field Binning!

 

I was wrong though about the Tile tool since we need very specific percentages and rankings per department, so I tried it out myself @rjesus1987 !

Labels
Top Solution Authors