Challenge #167: Grand Prix 2019

[ianwi]

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.

[jasperlch]

Solution attached.

[PhilipMannering]

Going by year alone you appear to get two answers. But if you assume they win at the last (max) date of a Grand Prix within that season you can calculate the difference in days... and indeed Vettel was 165 days younger than Hamilton at the time of winning.

Spoiler

Workflow

[Verakso]

Once again a great challenge, and once again I am miles from the podium 🏁

Also I will not blindly concur to the result, since my first calculations found another young driver, but here it is

Spoiler

Took me a while to figure our which data to actually use.
I have not looked any further into the data, to see if the cross-relation was correct (point are stored in multiple sources), but I did manage to match the provided result

The Resultby building the workflow like this
The Workflow
I guess it depends on what the criteria really is. It could be that my logic and calculations are wrong, but if I look at age, related to days, then it is Lewis Hamilton that is the youngest driver and not Sebastian Vettel 😕Vettel or Hamilton is the youngest?

Still Climbing
/Verakso

[wdavis]

Got a bit stuck when I kept having Hamilton as youngest winner (not biased at all) until I realised that the points were cumulative throughout the season. Enjoyed the challenge, looking forward to seeing how other people completed this in a faster way!

Spoiler

Will

[ggruccio]

Was able to get answer without one of the tables. 

[Reesetrain2]

ALL,

So as it turns out:

Sebastian Vettel-8546 (Days Old)

Lewis Hamilton-8723 (Days Old)

Vettel was 177 days younger than Hamilton...

-This assumes the season on 11/25 of the year as that was the season end for 2018.

This one took me a while to figure out as I kept getting Hamiliton until I used the DateTimeDiff and then used "Days" versus "Years" on the sort, while carrying both through until a Select at the end, I also had to change the VW String to an Integer...

This was an interesting Challenge, as I used Summarize twice, once to get the cumulative point totals for the years of racing and then again to get the Maximum amount of points (winner) and then used a Join to get the winner, almost  like a filter.

-Cheers!

Matt

[nini]

My Solution:

[cgoodman]

Spoiler

Here's my solution, it works but I've just calculated the age based on the racer's age for the last race of the season where as I think it would be better to find the race where they win the Championship (which may not be the last race).

[NancyS]

Hi @ianwi , here's my solution!

Nancy

[catarina_pimpao]

Spoiler