Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #167: Grand Prix 2019

Highlighted
Asteroid

thanks

Highlighted
Alteryx Partner

Not quite as clean as I would like it - I kept finding little "ooops, I forgot 'x'" bits, so there are certainly some tool redundancies here

 

 

Spoiler
Process (working left to right and top to bottom - mostly):
- Group races by year and date to find the most recent date (for calculating age of driver upon championship)
- Filtered race results data to capture top 10 for each race
- Joined race results and race details data
- Grouped by year and driver to take sum of points
- Sorted and sampled to determine top driver for each year
- Captured driver date of birth
- Combined first three strings discussed above
- Calculated age of driver (in both years and days) at championship
- Sorted by Age in days to serve as tie-breaker
- Joined with clean-up name of team
- Sorted by Age in Days
- Calculated Youngest and Oldest driver
- Joined and cleaned up for the win

MySolution.PNG

 

 

Asteroid

done

 

Spoiler
there were two who were 23 years old, so I needed to calculate the value in days
image.png
Highlighted
 
Highlighted
Atom

boom!

Highlighted
Asteroid

Done...

Spoiler
clipboard_image_0.png
Highlighted
Asteroid
 
Highlighted
Asteroid
 
Highlighted
Alteryx Partner

Kept on getting the wrong answer, then realised I was reading months as minutes...

 

Spoiler
Challenge 167.png
Highlighted
Asteroid
Spoiler
Challenge 167.JPG