Challenge #169: Women's World Cup Wins

[Inactive User]

Spoiler

Ties through me off but good start to the week!

[angelina4248]

Spoiler

Spoiler.

[acastelazo]

Spoiler

[JSNelson08]

here's my solution to the World cup question.  

Spoiler

[patrick_digan]

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

[ddiesel]

My solutions:

Spoiler

[dho111]

My solution

Spoiler

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

Spoiler

[Bob_Tukker]

Spoiler

Spoiler

here's my solution