The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
My solution 🙂 Used a multi row formula so a little more complex than the posted solution. Really glad I saw the solution posted using the tile tool - hadn't used this before!
First challenge and approached it logically like I would in Excel or Tableau by sorting on count and then assigning a rank by reading the table top to bottom comparing prior row to current row. That's it!