Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #161: Triangles, Triangles, Triangles

Niklas
8 - Asteroid

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

Karam
8 - Asteroid

Fun challenge!

 

Spoiler
Challenge 161.PNG
JoshuaGostick
11 - Bolide

My solution 🙂

 

Spoiler
challenge_161.PNG
OllieClarke
15 - Aurora
15 - Aurora

This was trickier than I thought it would be

 

Spoiler
Challenge 161.png
delilah
8 - Asteroid
Spoiler
キャプチャ.JPG

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

ZenonH
8 - Asteroid

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

Spoiler
ZHSOL.png

CailinS
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
Customer Experience
LukeG
Alteryx Alumni (Retired)
Spoiler
Challenge_161_LG.PNG
mbogusz
9 - Comet

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
SueDonim
8 - Asteroid

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