Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!
Really enjoyed this one.
First time I ever used the Tile tool which gave me the initial 1-12 rank and after a bit of experimenting I finally figured out how to have multiple people in the same rank :)
Satisfied with a 3 tool solution. Same as @Rachel_Burge. See a few using Tile tool. I must learn what that does..
Another fun challenge. Here's my solution:
Spoiler
1) Ordered by count descending.
2) Used a multi-row formula to create a new rank field that compares the current row count with the previous row count and either copies or increments the rank.
3) Added 1 to my rank scores as they initialised at 0.
4) Filtered the top 5.
1) Ordered by count descending.
2) Used a multi-row formula to create a new rank field that compares the current row count with the previous row count and either copies or increments the rank.
3) Added 1 to my rank scores as they initialised at 0.
4) Filtered the top 5.
