Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
Not applicable
Spoiler
Ties through me off but good start to the week!
angelina4248
6 - Meteoroid
Spoiler
Spoiler.


169.png
acastelazo
8 - Asteroid
Spoiler
Capture.JPG
JSNelson08
8 - Asteroid

here's my solution to the World cup question.  

 

Spoiler
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.

Spoiler
Capture2.PNG

Capture.PNG
ddiesel
13 - Pulsar
13 - Pulsar

My solutions:

 

Spoiler
Capture.JPG
dho111
7 - Meteor

My solution

Spoiler
spoiler.JPG
john_miller9
11 - 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.

 

Spoiler
challenge_169.png
Bob_Tukker
6 - Meteoroid
Spoiler
Spoiler

here's my solution

phottovy
13 - Pulsar
13 - Pulsar