community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #67: Calculate Spatial Angles

Alteryx Certified Partner

So the first part of doing it only using Spatial tools was straight forward fun

 

The other part - not so much, but I gave it a go - after all, how hard could it be?

Especially since I have just helped the daughter with some high school trigonometry - now I am afraid she won't pass her grades with her fathers assistance 😂

 

Spoiler
So the Spatial part was pretty straight forward. Okay I might have some assumptions in the calculations but still, there is a reason for using the Spatial Tools.

High on this success, I decided to try on the non-spatial approach, and here a couple of hours later, here is my result.
2019-05-15 16_22_11-Alteryx Designer x64 - challenge_67_start_file.yxmd_.pngWeekly Challenge #067Looking at some of the other solutions, especially the official by @JoeM is must admit I am not impressed with my Alteryx Formula / Math Skills - so I guess I just stick to the Spatial Tools that I love ❤️

But on the fun side, I did get to use the Switch condition, which I have wanted to do in a long time.

 

On my way to Lhotse Face

/Verakso

Asteroid
 
Alteryx Certified Partner
Alteryx Certified Partner

Challenge #67, done.

 

Spoiler
Challenge_67.PNG

 

 

 

 

Cheers,

Asteroid

'Some Old Horse Caught a Horse Taking Oats Away'

Used Way to many tools, but I'll consolidate later 

Highlighted
Comet

Not sure why non-special (trig) is giving a slightly different answer.  Used ACOS instead of ASIN and my distances matched the solution when I checked them (check not in final solution).  When I ran the posted solution using ACOS it matched my answer.  Trigonometry should give the same result for ASIN (length Opposite/length Hypotenuse) as ACOS (length Adjacent)/length Hypotenuse).  Let me know if someone knows differently.

Spoiler
 Workflow 67.GIF

 

 

Asteroid

My solution. Both with and without spatial tools.

 

Spoiler
challenge 67 solution Eleonora Nazander.JPG
Alteryx Certified Partner
Spoiler
67. Spatial.PNG
Didn't even need the bottom bit, but I did so I could do Pythagoras originally. The distance tool did all the work for me! 
Asteroid

solution attached

Asteroid

Thought I was going to need to dust off the Trig functions until realized the distance tool could give the direction in terms of degrees.

Asteroid

Here's my solution using the spatial tools.

Spoiler
Challenge 67.PNG