Multi Row Ranking - skip numbers where there are duplicates

Hi,

I have created a workflow that will use the multi-row formula tool to rank values depending on whether the next value in the table is a duplicate.

I currently have the following:

How would I update this workflow so that the duplicates "skip" a number when the rank is tied - like this:

Thanks!

Data Investigation

Accepted answers

binu_acs

@srea541 One way of doing this

Ranking_1123.yxmd

All comments

JamesCharnley

Hi @srea541

This ended up being more a tad more confusing than I expected so I expect someone else might chime in with something a bit more efficient but this works.

The first multi row was just to match what I assume you've got so far. Then I've added a Record ID to later reference in the Multi rows. The first multi-row after is then checking to see if there is any tied records before it, and if there is then it calls the record ID, which is its natural rank including the ties. This works for the first instance of that percentage only. Then that field is being updated in the second one to fill that rank down if it's less than the row before it. Hopefully that makes some sense, feel free to ask a question if not

UpdateRank.yxmd

binu_acs

@srea541 One way of doing this

Ranking_1123.yxmd

Qiu

@srea541
There are several related weekly challenges related to your question. Maybe you want to give a look.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-122-Think-Like-a-CSE-Ranking-Data/td-p/177006

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-9-Analytics-Ranking/td-p/36736

srea541

Thank you all! @binu_acs your solution worked as required

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703