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
適用対象外
スポイラ
Ties through me off but good start to the week!
angelina4248
メテオロイド
スポイラ
Spoiler.


169.png
acastelazo
アステロイド
スポイラ
Capture.JPG
JSNelson08
アステロイド

here's my solution to the World cup question.  

 

スポイラ
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.

スポイラ
Capture2.PNG

Capture.PNG
ddiesel
13 - Pulsar
13 - Pulsar

My solutions:

 

スポイラ
Capture.JPG
dho111
メテオール

My solution

スポイラ
spoiler.JPG
john_miller9
ボリード

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.

 

スポイラ
challenge_169.png
Bob_Tukker
メテオロイド
スポイラ
Spoiler

here's my solution

phottovy
13 - Pulsar
13 - Pulsar