The solution to last week's challenge can be found HERE.
This week, we get back to spatial! A wireless carrier wants to geolocate or triangulate the location of a device/user based on the location of nearby cell towers and the device/user by determining the azimuth. As a result, they would like to calculate the angle (in degrees) between two points where a line is drawn from the lower point directly horizontally towards the other point.
Bonus: Try solving one way with the spatial tools, and another using no spatial tools!
My solution, two ways - one with spatial tools, one without! 🙂
PS. Holy trigonometry, I had to dig deep for that one. My high school self is very disappointed with me right now for apparently forgetting everything I once knew about calculating angles...
Oh gosh my way is super hackish and I didnt know how to do the bonus. I've had a look and there are definitely a lot of spatial features I am not familiar with, especially the functions, nice to learn from other's answers.
So - full credit goes to this site which explained the full math of the great circle distance; provided pseudo code in Java / excel formulas; etc. http://www.movable-type.co.uk/scripts/latlong.html
I fully admit I don't understand the derivation of these formulae, but at least a little smarter now on how to use some of the trig & distance functions in Alteryx
This solution contains both spatial & basic trig version, and the non-spatial calculates both distance and angle fully using trig.
To @NicoleJohnson 's point - who would have ever thought that a subject like "Math" would come in useful one day...
Possibly one-day, I may find a good use for some of the other subjects we did in school like accounting; computer science; Inglish Wrting; etc. 🙂
Hopefully, my spatial solution will count as spatial since I used only one spatial tool.
I also have to admit a trigonometry defeat as I am sure 16 formulas were unnecessary and the answer I got was anyway smaller by ~1,5 degrees. That being sad, my spacial answer is also a bit off but I guess it can be a rounding error.