community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #167: Grand Prix 2019

Asteroid

thanks

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