Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #161: Triangles, Triangles, Triangles

Highlighted
8 - Asteroid

Got to the end and realised that a third of the tools I used were superfluous 😉

Highlighted
Alteryx Certified Partner

Fun challenge!

 

Spoiler
Challenge 161.PNG
Highlighted
Alteryx Certified Partner

My solution 🙂

 

Spoiler
challenge_161.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

This was trickier than I thought it would be

 

Spoiler
Challenge 161.png
Highlighted
Alteryx Certified Partner
Spoiler
キャプチャ.JPG

Thanks to the Unique Tool, everything gets easier because of it!!!

Highlighted
8 - Asteroid

My browse looks a little different, but I still got 516 records. 

Spoiler
ZHSOL.png

Highlighted
Alteryx
Alteryx

thanks @LukeL for leading this fun example in our first DFW Alteryx FlowMasters sessions. Thanks to @MargaritaW @CristianoJ @TrevorY for bringing FlowMasters to the Plano office!

Cailin Swingle
Sr. Manager, Customer Support
Highlighted
Alteryx
Alteryx
Spoiler
Challenge_161_LG.PNG
Highlighted
8 - Asteroid

I had fun playing with the sorts too @TonyA.

 

Above and beyond @NicoleJohnson. Thank you.

 

Spoiler
Attempt 1 (this included lines and polygons)Attempt 1 (this included lines and polygons)Final solution sorted AreaSqMi descending, pretty cool!Final solution sorted AreaSqMi descending, pretty cool!The workflow with Browse's (or the like) at every junctureThe workflow with Browse's (or the like) at every juncture
Highlighted
Alteryx Partner

I'm stumped.  I get 552 triangles, and I don't see the problem with my logic.  Also my picture looks very different from everyone else's.  But it is quite symmetric and seems right, even if it is hard to read.  Any thoughts would be appreciated

 

Spoiler
Process:
- Create points from the Lats and Longs
- Append fields on points (on itself)
- Append fields of points with above combined points
- Mark as collinear if either 1) all three latitudes are the same or 2) all three longitudes are all the same
- Filter out collinear records
- Filter out non-unique records (since some triangles could sit on top of each other)
- Create triangles from all sets of three points
- Clean-up

MyTriangles.PNGMySolution.PNG