This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackI 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.
My solution
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.
here's my solution