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 #122: Think Like a CSE...Ranking Data

fvojtesek
8 - Asteroid

My solution.

allwynthomas24
11 - Bolide

The RANK() function is a window function could be used in SQL Server to calculate a rank for each row within a partition of a result set. The same rank is assigned to the rows in a partition which have the same values. The rank of the first row is 1 (hint). Thanks @JohnPo for this Challenge...

 

Spoiler
allwynthomas24_0-1642425127695.png

 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 122.png

leozhang2work
10 - Fireball
Spoiler
122.png
yatish1164
7 - Meteor

Tried using Make group, gave up on it and used Multirow formula instead!

Robertas
6 - Meteoroid

My solution.

Ann_Macharia
6 - Meteoroid

Challenge 122 , SQL rank in Alteryx - Solution workflow!

karlynlarson
8 - Asteroid

my solution

FrederikE
13 - Pulsar

That was a fun Challenge :)

usmanghayoor
8 - Asteroid

Solution!