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

Bingo, perfect match with the output

Highlighted
7 - Meteor

Answer is off from solution output, but matched with others.

Highlighted
Alteryx
Alteryx

fun challenge!

 

Spoiler
seinchyiwoo_0-1591068094478.png

 

Highlighted
Alteryx Certified Partner

Fun challenge!

 

Spoiler
I could read that there was some, who did not the the exact same result, and I have no idea what could be so much different than mine, but that one does match
My SolutionMy Solution

 

The only thing I can think of, is our assumption, on how to rank the drivers and the races.
I have simply grouped by driver and race, and then summarized on the lap time, and counted the number of laps.
Then I sorted by race name, number of laps descending, and total lap time, based on who ever driver that managed to make most laps on the shortest time, is the winner.
The rest is the ranking, joining points, counting and find the top 3.

Still Climbing
/Verakso

Highlighted
Alteryx Partner
Find the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-217-A-Fast-Blast-From-The-Past/td-p/576962
Highlighted
7 - Meteor

Here is my version of solution:

 

Spoiler
vsetia46_0-1591117689100.png

 

Output:

vsetia46_1-1591117741616.png

 

 

Highlighted
Alteryx Partner

This was a fun reminder how not to use the Tile Tool! 

 

Spoiler
JustinBabbitt_0-1591130252596.png

 

Highlighted
7 - Meteor

Challenge completed, see attached.

Spoiler
MConidaris_0-1591195637601.png

 

Highlighted
12 - Quasar

My solution.

Spoiler
RNO2_0-1591230521594.png

 

Highlighted
8 - Asteroid
Spoiler
sonyakasenkramer_0-1591240600890.png