Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #384: Uncover Tennis Stats Upsets!

bmerril6
7 - Meteor
Spoiler
Challenge 384 Snip.JPG
Filter to just the Finals rows.  Convert WRank/LRank to Double.  Determine Rank Difference.  Summarize tournaments by number of Finals.  Filter to tournaments with greater than 19 Finals.  Sort by Avg. Rank Difference.  Find Tournament with highest rank difference.  In separate workstream, determine the number of times each winner won in each tournament.  Join the two outputs by the tournament from your first workstream, thus filtering to just the winners of that tournament.  Sort by most wins, then filter by the top option.  Andujar P.  3 wins.
Paridhi_Agrawal
8 - Asteroid

Attached is the solution

Ray_Pospisil
8 - Asteroid

Alteryx and SQL solutions

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 2023-08-17 163406.jpg

eacheson
7 - Meteor
Spoiler
 
Screenshot 2023-08-17 102732.png

 

Tofel
9 - Comet
Spoiler
Challenge 384.JPG
rmassambane
11 - Bolide

384!

Qiu
21 - Polaris
21 - Polaris

Done.

Spoiler
challenge_384.PNG
martinding
13 - Pulsar
Spoiler
384.PNG
mattnason1
9 - Comet

Nice quick one.