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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
alteryx Community

# Weekly Challenge

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

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

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

Submit Feedback

## Challenge #217: A Fast Blast From The Past

Alteryx

A solution to last week’s challenge can be found hereSource: https://en.wikipedia.org/wiki/Formula_One

Formula 1 racing is one of the most popular sports in the world and the 2011 season is considered one of the most dramatic in history! If you aren't familiar with this category of racing, know that F1 cars are the most sophisticated race cars in the world and they are created by legendary automobile manufacturers.

Each season, teams travel to different locations around the world to compete in races. At the end of the season, awards are presented to the top driver and top team based on a point scoring system. The scoring system awards points to both drivers and teams at the conclusion of each race (the scoring is presented in the Points table). Since the races take place at different race tracks, each race has a unique number of laps. Additionally, races are constrained to a 2 hour window. This means not all races will complete the scheduled number of laps.

For this week's challenge we have provided a sample of lap data from the 2011 F1 Season covering races 4 - 17. You'll find each driver's times for every lap completed in each race. Use the Race Data to figure out who finished in the points for each race and find the top three racers across this 13 race sample.

16 - Nebula

My answers are a little off, but I didn't see anything glaringly wrong.

Spoiler

12 - Quasar

My answer differs a bit from the given answer but I'm confident in what I have...

Fun challenge!

Spoiler

EDIT : Added link to my video walk through and corrected statement at top of post.

Spoiler

11 - Bolide

Same as Patrick above. What are we missing?

Spoiler

10 - Fireball

I agree with @patrick_digan. My results match his.

I spent some time just now on this site: https://www.formula1.com/en/results.html/2011/drivers/JENBUT01/jenson-button.html and my race-by-race results match exactly.

Spoiler

View my solution video here:

Spoiler

11 - Bolide

Fun challenge this week, however my total points are off compared to the provided solution:

Spoiler
Alteryx

Thanks for pointing out the error @patrick_digan @Blake @dsmdavid @johnemery @Aaron_Harter !

The Output Text Input values were from a previous version of the challenge...The workflow has been updated.

12 - Quasar

My answer was different but match with updated workflow.

Spoiler

15 - Aurora
Spoiler

15 - Aurora

Fun challenge, like others, my results do not match the expected values.

Spoiler