Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #169: Women's World Cup Wins

Inactive User
Non applicable
Révélation
Ties through me off but good start to the week!
angelina4248
Météoroïde
Révélation
Spoiler.


169.png
acastelazo
Astéroïde
Révélation
Capture.JPG
JSNelson08
Astéroïde

here's my solution to the World cup question.  

 

Révélation
Challenge_169.png
patrick_digan
17 - Castor
17 - Castor

I love using @jdunkerley79's VarNum and VarText functions that he added in v1.4 of his alteryx abacus tools. The formula tool looks a little verbose when you get done, but they're easy to work with while building.

Révélation
Capture2.PNG

Capture.PNG
ddiesel
13 - Pulsar
13 - Pulsar

My solutions:

 

Révélation
Capture.JPG
dho111
Météore

My solution

Révélation
spoiler.JPG
john_miller9
Bolide

Leveraged the summarize tool twice - first to group wins by team, and second to figure out the max wins and join back to the wins by team summary.  In this case, you get the same answer as a summarize, sort desc, and sample tool, but that wouldn't be the case if multiple teams tied for the most wins.

 

Révélation
challenge_169.png
Bob_Tukker
Météoroïde
Révélation
Spoiler

here's my solution

phottovy
13 - Pulsar
13 - Pulsar