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
Attempted to rank using multi row formula, but couldn't get it to work. Ended up having to refer to solution. I just have a hard time conceptually with summing & re-joining at this point. I'm sure I'll get there with more practice.
I used the multi row formula tool with an additional formula applied after to get the rank to start at 1 instead of 0. I also added in the tile tool (seen in other comments) just as a check since it was my first time seeing that tool.