How to Rank in Alteryx

[rjesus1987]

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.

Name	Dept	Score	Ranking
John	AB	2
Mike	BC	4
Karen	AB	5
Dave	BC	2
Dawn	BC	10
Jacob	BC	8
Ryan	AB	6
Selena	AB	7
Aileen	AB	3
Jeremy	BC	4
Steve	BC	8

[alexnajm]

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

[OTrieger]

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]

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]

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 · Accepted solution]

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 !