Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

AdrienGohy
8 - Asteroid
Spoiler
Adgo57_0-1573055175094.png
kmcdaniel
8 - Asteroid
Spoiler
screenshot26.png
Parul_Kapoor
8 - Asteroid

Solution attached.

DanielLing
8 - Asteroid

I completed the straight line miles but couldnt do the drive miles due to not having the additional mapping data!

Illya
8 - Asteroid

My solution. Bread and butter, nice and easy 2 tools for the straight line.

Feel a bit sorry for the technician but on the bright side maybe they are doing a tour of all the hotels in the area...

Socking up on toiletries no doubt, you know how these technicians are... hmm don't feel sorry for them any more.

SueDonim
8 - Asteroid

Sailed through this one pretty well

 

Spoiler
Process:
- Multi-Row tool to bring spatial object from subsequent row
- Calculate linear distance from Object 1 to Object 2
- Add Record ID to enable filtering of data
- Formula to create Null value for distance for every 3rd row (If Mod(Distance), 3) = 0, then Null)
- Add Distance travelled each day

MySolution.PNG
Borja_Leiva
7 - Meteor

Here is my solution for distance in Straight Line

AmeliaG
Alteryx
Alteryx
Spoiler
26_screenshot.png
MFish
8 - Asteroid

Could only do the straight line distance. I often over-complicate and overthink these challenges but this one was super quick and easy.

SimonSturges
7 - Meteor

Spoiler
Screenshot_2019-11-17 15.44.14_LLIPYc.png