HiI want to make a rank.I can make a same(Group) rank.But, I want to next rank is not "+1" rank.
Example
How can I make it?
To achieve this you can use a couple of multi-row formula tools stitched together.
The first one to calculate the running number of 'ties' and the second then uses this field to create the rank.
IF [Row-1:Score] = [Score] THEN [Row-1:Ties]+1 ELSE 0 ENDIF
IF [Row-1:Ties]>0 AND [Row-1:Score] != [Score] THEN [Row-1:Rank]+1+[Row-1:Ties] ELSEIF [Row-1:Score]=[Score] THEN [Row-1:Rank] ELSE [Row-1:Rank]+1 ENDIF
Example attached based on your sample data...
Ben
Thank you！
I got it!!!!!!
Just want to say thank you, Ben, for the screenshots.
Very helpful for those of us searching for tutorials!
That's awesome but I've run into a problem when I try to keep the rankings to within groups. Do you know how I might be able to fix it?
I used the same 2 tools and ticked the Group by 'Group' box but get this when I get to the second group;
See this Weekly Challenge
Challenge #9: Analytics Ranking
For this challenge let’s look at ranking records when multiple records can have the same rank.
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-9-Analytics-Ranking/td-p/36736
