Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Hi Maveryx,
A solution to last week’s challenge can be found here.
Are you already missing Inspire 2024? If you did not have the chance to attend the conference, the next three challenges will give you a taste of what our competitors faced during the incredible Grand Prix event, which celebrated its 15th anniversary this year. The year 2024 also marks 30 years since the tragic passing of Formula 1 driver Ayrton Senna.
A huge congratulations to Molly Harras on winning the 2024 Alteryx Grand Prix! If you are not aware, Molly won the Grand Prix for two years in a row: 2023 and 2024. Her incredible skill and dedication have shone through!
The Grand Prix challenges are divided into three laps:
Lap 1: Data Blending and Preparation – June 10
Lap 2: Spatial Analysis – June 17
Lap 3: Predictive Analysis – June 24
Pit stops during a race can make or break a team. Using the provided datasets from three different races (Qatar, Silverstone, and Japan), identify the driver who executed the fastest individual pit stop, measured from entering to exiting the pit lane.
The solution should consist of a single row containing the following data points: [Driver], [DriverNumber], [Race Name], and [PitStopTime] (in seconds).
Note: Truncate times to the second before you determine the pit stop duration.
Feel free to use the hints provided in the workflow.
Need a refresher? Review these lessons in Academy to gear up:
Good luck!
My solution.
My (dirty) solution :