I'm not sure if you know it, but Alteryx isn't the only organization that puts on a Grand Prix. Turns out they are pretty common for something called Formula 1.
This week's challenge gears up for the 2019 Grand Prix by taking a look at race data from 1950-2018. In Formula 1, points are awarded to the top 10 drivers after each race. After all the races in the year, the driver with the most points is named champion. Drivers also represent their teams in the "Constructor's Championship". (Constructor = Team) Use the provided data to find the youngest and oldest ever champions, and what team they drove for during that season.
C:\Users\pburrows\Downloads\challenge_167_start_file\Driver Profiles.yxdb
Driver Profiles.yxdb
C:\Users\pburrows\Downloads\challenge_167_start_file\Driver Standings.yxdb
Driver Standings.yxdb
C:\Users\pburrows\Downloads\challenge_167_start_file\Race Details.yxdb
Race Details.yxdb
C:\Users\pburrows\Downloads\challenge_167_start_file\Race Results.yxdb
Race Results.yxdb
C:\Users\pburrows\Downloads\challenge_167_start_file\Team Details.yxdb
Team Details.yxdb
C:\Users\pburrows\Downloads\challenge_167_start_file\Solution.yxdb
Solution.yxdb
year - Ascending
date - Descending
year - Ascending
Sum_points - Descending
First
1
First 1
First
1
First 1
Right_dob
dd/MM/yyyy
DateTime_Out
Convert Right_dob From:
dd/MM/yyyy
Age at win = DateTimeDiff([date],[DateTime_Out],"Months")
Age = [Age at win]/12...
Age - Descending
Age - Ascending
First
1
First 1
First
1
First 1
Horizontal
challenge_167_start_fileDone