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
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

Adedoyin
5 - Atom

Hello,

 

I think i might have taken the easiest way out on this one but attached is how i tried to solve this challenge.

 

Adedoyin_1-1647513860011.png

 

I have gone through some of the other solutions as i am trying to familiarize myself with the so many tools in altertyx. 

Is there a way way to automatically assign the ranks as i have realized i might not be able to write out a very long formula if the data set was larger.

 

NikkiJain
7 - Meteor

Here's my solution:

 

PatrickW_
Alteryx Alumni (Retired)

#9 challenge will always be #1 in my heart

MohithRai
8 - Asteroid

Done🚀

Spoiler
MohithRai_0-1647856516442.png

 

gdybowski001
7 - Meteor

Started out with > rather than != in my multi row formula and got a ranking starting from 0. Interesting challange

usmanghayoor
8 - Asteroid
Spoiler
usmanghayoor_0-1647972877413.png

 

atasi_jain
7 - Meteor

Solution for Challenge #9

raeaton
8 - Asteroid

My solution!

Spoiler
Challenge9Flow.PNGChallenge9Finding.PNG
mindyzhang99
8 - Asteroid

finished

Diederik_vanderharst
8 - Asteroid

Voila

Spoiler
Schermafbeelding 2022-03-24 om 10.27.51.png