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 #344: World Cup Sweepstakes (Part 1)

DanielG
12 - Quasar

Solved

Erin
10 - Fireball
Spoiler
344.png
Supriya2203
8 - Asteroid

Split the dataset to have one good rank

lwolfie
11 - Bolide

Didn't know you could post too many solutions in a row.  I guess I should post as I go.

snothando_hlongwane
8 - Asteroid

Challenge #344 Solution

cmoussa
8 - Asteroid

WF.png

 

Bennu
8 - Asteroid

Fantastic, creative, fun, open end, challenge!

With 2 nested Iterative macros, I might have over engineered it a bit...  But It's as fair as it gets, with each participant getting 1 out of 5 from each group of 5 similarly ranked teams.  Shame Alteryx does not allow the same macro to be called recursively.. that would have saved some work.

 

Also a shame the Random sample does not return scrambled records (randomized order) when you pick a sample of 5 out of  5 records!! What's up with that? @academy 

RecursiveMacros.jpg

 

Anyway.. here's the full solution.

Spoiler
WC_344.jpg