Multi Row Ranking - skip numbers where there are duplicates

[srea541]

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!

[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

[binuacs · Accepted solution]

@srea541 One way of doing this

[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/1...

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

[srea541]

Thank you all! @binuacs your solution worked as required :)