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 #217: A Fast Blast From The Past

Highlighted
Alteryx Certified Partner

My solution

 

Spoiler
challenge_217.PNG
Highlighted
12 - Quasar
12 - Quasar

My solution.

Spoiler
Challenge 217.png
Highlighted
5 - Atom

Fun challenge! 

 

Other than basic steps, I also added a few steps to ensure racers who didn't finish all laps don't get points.

 

Spoiler
My solution.PNG
Highlighted
8 - Asteroid

According to wikipedia there is a scoring wrinkle: "To receive points a racer need not finish the race, but at least 90% of the winner's race distance must be completed". As close as I can tell the provided solution does not cover that eventuality, although admittedly given this data set it does not change the result

 

Tberney_1-1591556741780.png

 

 

Highlighted
5 - Atom

My solution. thanks.

Highlighted
7 - Meteor

Spoiler
WJJW-1_0-1591713113323.png

 

Highlighted
7 - Meteor

Wish I had done this one right away but I finally found some time at the end of today. Great challenge for those getting started or doing core prep. Get's you thinking about data and ranking. Solution attached with flow spoiler image below.

 

Spoiler
HINT: When summarizing the data, think beyond total time - those who didn't finish the race will have a shorter time but may still place.

217 - Solution.PNG
Highlighted
11 - Bolide

My solution is a bit over-complicated, because I wanted to attempt to handle ties, and figure out what to do if <10 drivers finish the race. In this particular dataset there were no ties, so it doesn't affect the result.

 

I found this:

"Points are awarded to drivers and teams based on their finishing order. The winner receives 25 points, the second place finisher 18 points, with 15, 12, 10, 8, 6, 4, 2 and 1 points for positions 3 through 10. If a race is stopped before 75% of the scheduled race distance has been completed, the points awarded are cut in half. If two or more drivers tie for a position, prizes and points are added together and shared equally for all those drivers who tie. Constructors receive points as well as drivers. Each constructor receives the same amount of points that their two drivers earned."

 

Since we aren't given the total number of laps for each race, I didn't check for the 75% completed rule.

 

Spoiler
kelly_gilbert_0-1591810499799.png

 

kelly_gilbert_1-1591810519763.png  

 

Highlighted
7 - Meteor

Really cool challenge for a F1 fan. I am looking forward for the first GP of the 2020 season! Would love to have more sport examples.

 

Highlighted
6 - Meteoroid

My solution...