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
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #9: Analytics Ranking

casianatarita
7 - Meteor

solution

ahsanaali
11 - Bolide

See solution attached.

gerda
8 - Asteroid
Spoiler
Spoiler.png

Here's my solution!

kavyadeva17
5 - Atom

Pfa

sknowlesHS
7 - Meteor

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. 

ZacharyRyanTIL
8 - Asteroid

My solution:

NermineObeng
8 - Asteroid
Spoiler
NermineObeng_0-1658308352367.png

 

My Solution

BeautiFolData
7 - Meteor

Thanks

mackenzie_short
8 - Asteroid

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.

martinding
13 - Pulsar
Spoiler
SpoilerWeChat Screenshot_20220726083016.png