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

MichaelSu
Alteryx Alumni (Retired)

See attached.

ALexAn
8 - Asteroid
Spoiler
ALexAn_0-1588922364190.png

 

ncrlelia
11 - Bolide

Challenge 9

devX511
7 - Meteor

@mceleavey From your approach i come to know about Tiles. Thank you.

 

But beforehand i made the flow using Multirow Formula Tool.

MRod
8 - Asteroid
Spoiler
markrod30_0-1589168579315.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sharing my solution.

 

I have used only 3 tools to make it work.

 

Spoiler
Challenge_9_Emil_Kos.PNG
sumanthskumar
8 - Asteroid

This was surprisingly easy. 

loganmjung
7 - Meteor

I took note from @

 

 

 

 

 
 

 

 

 

SideSweep7
7 - Meteor

Two alternative solutions using the multi-row tool:

1) resulting in the outcome as per the original task - i.e., multiple players can share the same rank

2) assumes, that if two or more players share the same count, they tie the rank, but then the next rank is skipped (or several next ranks, depending on how many players share the same count); i.e. as is the case in racing, running, swimming, skiing, and all other "normal" sports 🙂

Mélanie
8 - Asteroid

I liked this one 😃