Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #369: Formula 1 Grand Prix (In)efficiency

nSpire
10 - Fireball
Spoiler
nSpire_0-1683320128480.pngnSpire_1-1683320142968.pngnSpire_2-1683320170841.png

 

 

 

CharlotteGuy
8 - Asteroid

I got the first part still working on the second. Def need more experience with Macros

YSHuang
6 - Meteoroid

Here's my solution.  answers using Distance and Find Nearest are not the same, but I can't figure out what makes the outcomes different.

Spoiler
F1_workflow.pngF1_Macro_Find Nearest.pngF1_Macro_Distance.png
Sebastian_Chaieb2
11 - Bolide
11 - Bolide

I am not happy with my macro (need to rebuild it), however it works (second result is smaller then in expected output) but I assume that is correct 

 

Workflow:

Spoiler
Sebastian_Chaieb2_0-1683541865035.png

 

Macro 

Spoiler
Sebastian_Chaieb2_1-1683541917810.png

 

ed_hayter
13 - Pulsar
Spoiler
ed_hayter_0-1683631125981.pnged_hayter_1-1683631140033.png
niklas_greilinger
11 - Bolide

Also got a different (better :D) solution for question2.

Spoiler
niklas_greilinger_0-1683707969109.pngniklas_greilinger_1-1683707978209.png

 

 

bkclaw113
10 - Fireball
Spoiler


bkclaw113_0-1683726553214.pngbkclaw113_1-1683726567685.png

 

 Not very happy with how I handled the iterations with this approach but it gets the job done

alexnajm
18 - Pollux
18 - Pollux

Agreed about the smaller "closest distance" answer!

Spoiler
Challenge 369 macro.PNGChallenge 369.PNG
nagakavyasri
12 - Quasar
Spoiler
Spoiler
Screenshot 2023-05-10 143747.png
TimJVR
7 - Meteor
Spoiler
TimJVR_0-1683791952808.pngTimJVR_1-1683791991973.png

 

Very simple solution using an iterative macro that also gets the shorter correct distance. Comments added to help those that might be struggling.