community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

lapin_dangelau_24
7 - Meteor
‎01-26-2023 12:57 AM

my solution

challenge_9_solution.yxmd
Reply
Ed2000
8 - Asteroid
‎01-30-2023 03:00 AM
Spoiler
Ed2000_0-1675076384008.png

 

challenge_9_start_file.yxmd
Reply
JimmyMcGrath
5 - Atom
‎01-30-2023 07:05 AM

Second Challenge of the day

challenge_9_start_file.yxmd
Reply
AlexSm
7 - Meteor
‎01-30-2023 07:06 AM
Spoiler
 Solution to Challenge 9

AlexSm_0-1675091102914.png

Multi Row Formula:

if [Row-1:count]=[count] then [Row-1:Rank] else [Row-1:Rank]+1 endif

 

challenge_9_start_file.yxmd
Reply
AnnaPetra
5 - Atom
‎01-30-2023 07:07 AM

My second challenge

Challenge 9.yxmd
Reply
Goggy
6 - Meteoroid
‎01-30-2023 07:08 AM

This is how I did Challenge 9!

 

 

Goggy_1-1675091314396.png

 

 

 

challenge_9_start_file.yxmd
Reply
Shubham_Gulati
7 - Meteor
‎01-31-2023 12:25 AM

Done!

challenge_9_start_file_SG.yxmd
Reply
0 Likes
caltang
17 - Castor
17 - Castor
‎02-01-2023 04:46 AM

Solved! 

 

Would be nice if Alteryx had an in-built Rank tool. Would help heaps! 

 

Spoiler
caltang_0-1675255557316.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
challenge_9_start_file_caltang_workflow.yxmd
Reply
0 Likes
gaoa
11 - Bolide
‎02-01-2023 08:28 PM
Spoiler
gaoa_0-1675312098687.png

 

challenge_9_start_file_gaoa.yxmd
Reply
0 Likes
Wasim7568
7 - Meteor
‎02-01-2023 10:09 PM

Challenge #9: Solution

 

challenge_9_solution.yxmd
Reply
0 Likes