Alteryx Weekly Challenge #9 (Multi-Row Formula)

by Priya Padham

The goal of this challenge was to determine the top 5 based on the count. However, some rows have the same count so the ranking would be the same for these rows.

Here is how the input data looked:

Firstly, I used the Sort tool to sort “count” in descending order, as the larger the count the higher the rank. Then I added the Multi-Row Formula tool to assign the ranks for each row using this IF statement:

if [count] != [Row-1:count] 
then [Row-1:Rank] + 1 
else [ROW-1:Rank] 
endif

This IF statement states that if count is not equal to the previous row, then add 1 to Rank. However, if count is equal to the previous row, then the Rank will also be the same as the previous row.

Here is a snippet of the final result: