Challenge #396: Analyze the Ultimate Motorsport - Formula 1

[AYXAcademy]

Hi Maveryx,

A solution to last week’s challenge can be found here. 

Are you a big fan of Formula 1? 

This challenge is an exciting part of the Alteryx Formula 1 Fanalytics event. 

Rev your engines and get ready to race to the finish. Your goal is to analyze driver lap time data and pinpoint the best driver in rainy conditions, making them the top choice for any wet race conditions.

Bonus: Tune in to a recording of the “Alteryx + McLaren: Formula To Success with AI & Analytics” webinar to hear from McLaren Racing CEO, Zak Brown, and Alteryx CIO Trevor Schulze on how McLaren and Alteryx ride the data wave using AI and analytics to conquer change. 

Source: All data provided for this challenge is entirely fictional.

[benjimoser]

My Solution

Spoiler

[MatthewGrant12]

solution

[PhilipMannering]

Solution attached,

 

Spoiler

[mmontgomery]

Took a minute to understand what was being asked

Spoiler

[AkimasaKajitani]

My solution!

Designer Desktop

Spoiler

I made 2 solutions.The upper one in screenshot is my favorite solution.The lower solution is fit for the sample output.

Designer Cloud(Designer Experience)

Spoiler

Trifacta Classic

Spoiler

 

 

[rmassambane]

396!

[nSpire]

Spoiler

[sp6116588]

Go Fanalytics!

[sp6116588]

Updated solution 

Why would the "best driver in rainy conditions" not be the driver with the fastest time in rainy conditions??

If I drove 93 secs in sunny conditions and 93 secs in rainy conditions, my delta is 0. But I'm still the slowest... 

Anyways, go Fanalytics!