Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHad tough time on the bonus part.
The first time I've used the spatial functions :) My angle answer from the formula tool method is out by 0.056 degrees, but I already reached my threshold for trigonometry, so I'm calling it...
I wish I could remember some of the formulas I learned way back in middle school. I was very sad i couldn't think of any of them for the non-Spatial route. It makes me enjoy the spatial tools that much more that can do those things for me! It took me a lot longer than I wanted because of the formulas eluding my memory.
Solution attached.
This is a tricky one for me. One thing new I learnt is that the angle returned from distance tool is based on Clock-wise from the North and hence not the same convention for long-lat angle. Needed to refresh geometry knowledge.
Forgot to post this last night. This one was a lot of fun. Glad to see that I remember high school trig. I used more tools than necessary for the bonus question because I wanted it to be easier to understand than just a huge blob of formulas in one tool. I'm also excited about this one because it's my 75th challenge completed. Besides another badge, it also means I've been averaging just about one challenge a day since I joined Alteryx 76 days ago.
Reposted with a couple of fixes: 1. Ensure consistent results if both points have same Lat (Y) value. 2. Avoid dividing by 0 if both points having same Long (X).