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