Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #29: Alteryx '16 Grand Prix (Race1, L1)

jasperlch
12 - Quasar

Solution attached.

dsmdavid
11 - Bolide

On hindsight, should have moved the union to the front, but I originally had a join there to test for players that were both pitchers and batters (didn't know they were all different)...

Spoiler
29.png
msicak
8 - Asteroid

manually arranging the fields and overlooking pitcher rank took me to 13 mins. would have been <10 otherwise, oh well :)

 

Spoiler
challenge29.png
blairmbailey
8 - Asteroid

Solution attached - thanks!

dominiklz
8 - Asteroid
Spoiler
Capture.PNG

nice excercise

MaxGiegerich
8 - Asteroid
Spoiler
Weekly Challenge 29.png

I got a bit more artistic with the layout of this one...

MaxGiegerich
8 - Asteroid

Apologies for the duplicate. Dodgy internet connection...

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

CHarrison
8 - Asteroid

My solution :) 

Syfer889
7 - Meteor

Okay, this is right down my alley! Sports Analytics. Loving it! However, where in the world is "team rank" coming from in the select tool at the end?????