Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #169: Women's World Cup Wins

Highlighted
5 - Atom
Spoiler
Ties through me off but good start to the week!
Highlighted
6 - Meteoroid
Spoiler
Spoiler.


169.png
Highlighted
8 - Asteroid
Spoiler
Capture.JPG
Highlighted
7 - Meteor

here's my solution to the World cup question.  

 

Spoiler
Challenge_169.png
Highlighted
15 - Aurora
15 - Aurora

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
Highlighted
12 - Quasar

My solutions:

 

Spoiler
Capture.JPG
Highlighted
7 - Meteor

My solution

Spoiler
spoiler.JPG
Highlighted
Alteryx Partner

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
Highlighted
6 - Meteoroid
Spoiler
Spoiler

here's my solution

Highlighted
8 - Asteroid