alteryx Community

# 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.

## Challenge #396: Analyze the Ultimate Motorsport - Formula 1

9 - Comet
Spoiler
I understand that Driver 9 had the lowest delta between avg rainy condition time vs avg overall time. However, Driver 1 has faster average times (overall, rainy conditions and sunny conditions). So, my choice is Driver 1.

8 - Asteroid

Solution

9 - Comet

Just poked around a few other solutions and not sure I agree with other's methodology.... I think the delta on Rainy lap average vs. the average of all other weather conditions to be more logical than just rainy vs. sunny. Also, the question should ultimately just boil down to the driver with the fastest lap average in the rain, no?

Spoiler
8 - Asteroid

A 'fast' challenge.

8 - Asteroid

Hi,

I used the summarize to get the lapt times based on driver and weather. Filtered sunny and rainy days joined them and used formula to get delta. Used the sort and sample to get the output