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 #26: Service Technician Travel Distance

KatieA
Alteryx Alumni (Retired)

Solution attached

Pang_Hee_Choy
12 - Quasar
 
annaprosvetova
7 - Meteor
Spoiler
annaprosvetova_0-1583578471621.png

 

mpennington
11 - Bolide

Solution attached. Excited to be able to solve this in only two tools. 

 

Spoiler
After getting the result in two rows for each date and then summarizing, I decided to try to write a second multi-row formula to solve and put the result in a single row for each date.  Both methods attached:

MP 26.png
Desmond
8 - Asteroid

My solution for straight-line distance

Normster
8 - Asteroid

After looking at how other workflows I'm beginning to wonder if my correct answer is just a fluke.

 

Looking at the data, I could see groupings by date (start, work, finish) so I created lines for each date group.  I then used the Spatial Info tool to provide distances and voila!

 

Almost too simple.

 

Normster

Ashley2
8 - Asteroid

Challenge 26 Complete!
My Solution;

Spoiler
Ashley2_0-1584547329508.png

 

DejairBenedicto
6 - Meteoroid

Challenge #26

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

Spoiler
This is my solution
atcodedog05_0-1584950210452.png

 

Ivyin702
7 - Meteor
Spoiler
Ivyin702_0-1585048181616.png

 

Had so much fun with weekly challenges!!!