Challenge #26: Service Technician Travel Distance

[OldDogNewTricks]

It is good to have these easy ones in here in order to make me feel better about the ones that take me over an hour.

[Lee_Gibbons]

Solution Attached

[PCORMIER]

Interesting challenge. My solution is attached.

[Aster]

Spoiler

A challenge a week makes me a geek :)

[Ruud]

My solution.

[Arishan]

My solution

[mceleavey]

I've been doing this a lot recently with a client, so I probably solved this quicker than other recent challenges...

Spoiler

I simply created a multi-row formula tool that takes the spatial object from the row above (remember to group by date!):



This means the spatial objects to be compared on a single row and so only a single spatial tool is required.
Then, I simply used the Distance tool to determine the distance (or drivetime, or drive distance) and summed the distance by date.

M.

[MarMu]

Cool small exercise, it's not often that I get to play with the Spatial tools section.

I'm not sure if the tool selection have been improved since this challenge was posted, but I just used two tools and a Select for header lignment. Had to check the suggested solution to see if it really was ment to be that simple. :)

Spoiler

[PrivateStorm]

My solution to challenge #26 is attached.