community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #173: Tour de France - Crow Edition

Alteryx Certified Partner
Spoiler
Screen Shot 2019-08-06 at 9.44.52 am.png
Meteoroid

My solution

Alteryx
Alteryx
 
Bolide

"If you can't be good be careful"

Spoiler
173.PNG
Alteryx
Alteryx

I went down the same path as many others, or you could say I took the same route!

 

Spoiler
Workflow.jpg
Alteryx Partner
Spoiler
clipboard_image_0.png

Solution 

Asteroid

My solution:

Alteryx Certified Partner

Distance in km threw me off a bit there!

 

Spoiler
challenge_173.PNG

 

Does anyone know the purpose of the La meme flag in Formula tool? Not what it's doing, but rather, why.

 

 

 

 

Spoiler

Same .3 second run time as solution, but with one less tool. The solution contains the Formula tool that flags the Stages mentioned in instr. that have same beg./end city. I wasn't sure why the solution contained this, since nothing was done downstream with it...

 

Capture.PNG

 

... unless the purpose was just to call out certain records that aren't being accurately reflected results under the current method, i.e. records that might require a little extra attention or different methodology.

 

On this note I played around with creating a convention for the two Stages w/ True La meme flag. One such approach might be to take the ratio of Bike_Distance to Bird_Distance for the rest of the population (False La meme flags), calculate the average of those ratios, then apply that average to the two True La Meme Stages that are currently returning 0 for Bird_Distance. In essence saying that on average there's a ratio between Bird and Bike distance, so if that average held true for these two Stages, this would be the bird distance. Attached as below in solution file. 

 

Capture.PNGadding about 27km to bird distance

 

 

Asteroid

My solution attached