Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #167: Grand Prix 2019

KeithZ
8 - Asteroid
Spoiler
2019-11-13_21-17-20.png
Axiom
7 - Meteor

My solution:

 

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

Here is my solution. 

 

Spoiler
Capture.PNG
tiffany_chen
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
apabonok
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

phottovy
13 - Pulsar
13 - Pulsar

My solution:

AmeliaG
Alteryx
Alteryx
Spoiler
167_screenshot.png
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1577995484462.png
paulburrows
8 - Asteroid

One more in the bag!