Challenge #6: Spatial Route

[gracec97]

Spoiler

[JamesCameron]

My effort - a nice little introduction to Spatial tools 🙂

Spoiler

[soha-elghany]

poly-line my way through life

[jackdaniels]

Spoiler

 

[ChrissD]

I was a bit stuck on trying to get this to work with Distance. I tried using cross tab to transform the data and don't really understand why that didn't work at all.

However, once I looked up which shape I needed (spatial info) it worked well. Almost too well, it took me a minute to realise that the first shape had done the heavy lifting for spatial info (creating the polyline). 

[Xlblaze]

I am not sure if this has gotten easier since it was first released but this seamed very stright forwards.

Spoiler

[kmcdaniel]

Spoiler

[SueDonim]

Hey, I'm getting the hang of spatial!  Very interesting.

Spoiler

Process:
- Pull forward destination centroid with Multi-Row tool
- Create line between start and destination centroids
- Calculate distance between start and destination centroids
- Summarise: Group by Rep, Sum of distance, Combine travel vectors
- Sort by LengthMi (desc)

[mheinze]

Good spatial exercise. 

[wanghyNY]

Good exercise for spatial data.

Spoiler

Good to know that Poly-Build has built-in group_by.