The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

Challenge #226: Flex-Ability

Tony_Castillo
ファイアボール
スポイラ
TC_bot_0-1595877712330.png

 

Nothing better than starting the week off with a little Trig, Lots of ways to tackle this one. First time using Spatial and was easier than anticipated. 

TonyA
Alteryx Alumni (Retired)

This is far from a beginner's challenge if you really want to get a correct answer. A not very accurate solution is attached.

 

 

スポイラ
2020-07-27_12-39-40.png
The solution provided in the start file just averages the coordinates of the endpoints. That would work if the earth was flat. I was looking for a point on a line (segment of a great circle) connecting Irvine and Broomfield that is equidistant from the two cities. None of these solutions get me there. The last is closest, it's still about six miles away from center and about a mile from the line.

 

 

nigelsh
メテオロイド
スポイラ
challenge 226.PNG
bsanders2009
アステロイド

I like using spatial tools because I don't know them well and this is a great way to learn.

 

Workflow:

スポイラ
bsanders2009_0-1595881750124.png

I used the Report Map tool to duplicate the map provided in the example:

スポイラ
bsanders2009_1-1595881812865.png

 

dsmdavid
ボリード
スポイラ
Absurdly proud of the main approach here. Back to primary school...
dsmdavid_0-1595881862678.png

Compass and bisector. Kind of. Shame Earth is not properly flat.Compass and bisector. Kind of. Shame Earth is not properly flat.

Qiu
21 - Polaris
21 - Polaris

Still weak about spatial...

スポイラ
226-en.PNG
Sashikumar
アステロイド

Multiple option 🙂 

ch_226.PNG

szade1
アステロイド

Here's my solution-

スポイラ
szade1_0-1595930242997.png

 

Himanshu_1984
アステロイド

Hi,

 

Here is my one solution.

 

 

JITHINPR
アステロイド

My solution