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. NameDeptScoreRankingJohnAB2 MikeBC4 KarenAB5 DaveBC2 DawnBC10 JacobBC8 RyanAB6 SelenaAB7 AileenAB3 JeremyBC4 SteveBC8 Ranking Sample.xlsx

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

Ranking Sample.xlsx

Workflow

Reporting

Accepted answers

alexnajm

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 !

How to Rank in Alteryx.yxmd

All comments

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

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 !

How to Rank in Alteryx.yxmd

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335