Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA... now if I could just figure out how to delete a double post.
Used two tools:
Sort: count (descending); First (ascending - not necessary but did it anyway)
Multi-Row Formula: "IF [Row-1:count]!=[count] THEN [Row-1:Rank]+1 ELSE [Row-1:Rank] ENDIF"
gmitch22,
This is good. However, in many cases, clients wish to see rankings like this (example): 1,2,2,4,5,6,6,6,9,10. This formula would produce an output that looks like this (example): 1,2,2,3,4,5,5,5,6,7. Using the record ID tool, each row can be given a number (after using the sort tool), so the number of record are preserved. Something like this in the multi-field formula tool:
IF [RecordID] = 1 THEN 1
ELSEIF [Row-1:count]=[count] THEN [Row-1:Rank]
ELSE [RecordID]
ENDIF
If there are subgroups that need to be ranked, a filter can be applied to each subgroup (after being sorted), each of those given a record ID, and the results can then be unioned together, and the aforementioned formula can then be applied in the multi-field formula tool to resolve tiebreakers and preserve the number of records. Hope this helps!
My solution
Thanks!