Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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
Nice and easy. Poly-build + Spatial Info and you got your answer.
My Solution
Spoiler
Solution Attached!
I tried to solve this a couple ways to see how the Formula tool can be used as a one-stop shop for some spatial analyses:
I tried to solve this a couple ways to see how the Formula tool can be used as a one-stop shop for some spatial analyses:
So, spatial not being my best suit I actually can't think of any other way I would have done this.
Spoiler
I first created a multirow formula which appended the centroid from above to the line below (grouped by REP) as the Origin city.
I then used the Distance tool to calculate the distance between origin and current city. I then summed by REP.
From the same multirow formula I then took another stream where I used the Poly-Build tool to create lines between the origin and current. Then I simply joined them back.
I then used the Distance tool to calculate the distance between origin and current city. I then summed by REP.
From the same multirow formula I then took another stream where I used the Poly-Build tool to create lines between the origin and current. Then I simply joined them back.
It was right so, yay me.
M.
