Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #167: Grand Prix 2019

Highlighted
8 - Asteroid
Spoiler
2019-11-13_21-17-20.png
Highlighted
6 - Meteoroid

My solution:

 

Spoiler
ParadoxuM_0-1574435735699.png
Highlighted
8 - Asteroid
Spoiler
Challenge 167 2019-12-09.jpg
Highlighted
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

This challenge is quite cool! Three important things to concern:

1) Concern different people could get same points in one year, so we could not simply use sort tool & sample tool to get the highest score, my solution is using sort tool & multi-row tool & filter tool to get all the highest score in one year.

2) Concern one driver could change its constructor in one year, so we could use each driver's last constructor in every year.

3) Concern same age of each year's winner, so we could use more precious value, such as winner's age by days.

Spoiler
Annotation 2019-12-26 113217.png
Highlighted
8 - Asteroid

Hi! This is my solution. 

I did not use the Driver Standing.yxdb for nothing.

Age At Win is calculated by using BOD and max race date. 

With two or more drivers with same age, birthday date is the difference to select the youngest. 

 

challenge_167_apabonok_spoiler.png

Highlighted
8 - Asteroid

My solution:

Highlighted
Alteryx
Alteryx
Spoiler
167_screenshot.png
Highlighted
8 - Asteroid
Spoiler
sonyakasenkramer_0-1577995484462.png
Highlighted
8 - Asteroid

One more in the bag!