Challenge #26: Service Technician Travel Distance

[AdrienGohy]

Spoiler

[kmcdaniel]

Spoiler

[Parul_Kapoor]

Solution attached.

[DanielLing]

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

[Illya]

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]

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

[Borja_Leiva]

Here is my solution for distance in Straight Line

[AmeliaG]

Spoiler

[MFish]

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

[SimonSturges]

 

Spoiler