Challenge #26: Service Technician Travel Distance

[GeneR]

The link to last week’s challenge (challenge #25) is HERE

This week’s challenge is a use case faced by one of our customers that can leverage the geo-spatial tools available in Alteryx.  If you have the spatial data available you can output your results as drive-distance, in the event that you do not have the drive-distance data available, please use the straight-line distance.  The basic tools and setup of the data needed will be identical.  Output results will be provided for both methods.  In the event that you use drive-distance and your results vary slightly from the sample output, it may be due to variance in the data set used for the exercise.

Use Case:  in order to audit their employee expense reports, a service company would like to calculate how far (in miles) their technician is traveling from their hotels, to the worksite, then to their destination hotel on a daily basis.

The Data:  The source is collected in a way that record 1 contains the spatial object for the beginning hotel for day 1, record 2 is the spatial object for the worksite for day 1, and record 3 is the spatial object for the ending hotel for day 1.  This pattern repeats for three successive days.

Find the distance on a daily basis the technician is either driving or straight line distance if you don’t have the spatial data available.

Enjoy!

[jennifer_owens]

attached

[chandler-gjino]

Attaching my solution

[lucascs]

Spoiler

[tristank]

Good practice with spatial data. Curious to see the min number of tools that were needed for this.

Should've cleaned up with the select tool my bad!

Spoiler

[dougbaron]

just used straight line

Spoiler

[The_Rad_Valentina]

Straight-Line was easy. Went with that. 

[mindyzhang99]

My Solution

[MitchellBliesner]

I wasn't able to get answers for drive time distance as my Alteryx only has TomTom AU data and gave me nulls. I did get the total distance for the route though. I hope this will still be accepted as a solution. 

Spoiler

[AndreeaS]

Spoiler

[RossKillington]

Spoiler