Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATried my first alteryx challenge today ..discovered tile tool thanks to mceleavey 🙂
Here is my 2 solutions.
Solution #1 is very short and inspired by @mceleavey that involved the use of Tiles Tool
Solution #2 is more logical. I basically used Summarize to group up the count, sort it and filter out top 5, then I used join to rank it.
My solution - liked the way I presented a little better but the text to rows tool makes it match the output.