text: 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.
  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 #173: Tour de France - Crow Edition
  
  Alteryx
  
  A solution to last week's challenge can be found here!
  
  The Tour de France is one of the most grueling competitions on the planet. Each year, incredibly fit athletes push the limits of human endurance to traverse some 3000+ kilometers (2000 miles) over about a three-week period ON A BIKE. Just finishing the race is an incredible achievement. But what do birds think about all this?
  
  In this challenge, use Designer and data from the 2017 Tour de France to determine how long the race was, as the crow flies. That’s right, calculate how far the race would be for a bird flying all stages of the race.
  
  This solution treated race days that started and ended in the same city as 0 km covered. Travel outside of racing was not included either (i.e. if the destination of one leg did not match the next leg’s origin, that distance was not included.
  
  8 - Asteroid
  Spoiler
  14 - Magnetar
  
  Here's my solution..
  
  Spoiler
  ACE Emeritus
  
  My solution!
  
  Spoiler
  Took me longer than it should have to realize that calculations were in km not miles. Doh!
  
  16 - Nebula
  
  My solution
  
  Spoiler
  11 - Bolide
  
  Solution is below
  
  Spoiler
  
  Pretty straightforward.  Interestingly the bike distance in the solution remained in miles, while the bird distance was in km. @danilang - yep miles was something I totally created and then "solved for" in my workflow. Updated workflow accordingly
  
  16 - Nebula
  Spoiler
  I couldn't even ride my bike the bird's distance in 3 weeks!
  
  12 - Quasar
  
  If the birds didn't fly to the next leg's origin, when the destination of the previous leg was different, then did they ride in the teams' vans?
  
  Spoiler
  18 - Pollux
  
  What's a "Bike" and how many horsepower does it have!
  
  @David-Carnes .  Maybe they take the Train
  
  Spoiler
  Slightly different tack than those before me.  Transpose to minimize the joins
  
  @john_miller9 :  I think the Bike distance in the input was already in KM.
  
  Dan
  
  8 - Asteroid
  
  Here is my solution