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 #233: The Truth Is Out There

KaneG
Alteryx Alumni (Retired)

I didn't like the idea of around 19% of records dropping due to not having corresponding coordinates, hence I employed a quick Macro to get the missing co-ordinates.

 

Spoiler
Here's the workflow and Macro, note the detour to allow someone to easily use the macro or not...
KaneG_0-1601430868945.png KaneG_3-1601431609993.png

 



And here's how the results differ:
Without the Macro (356 records dropping off) and then with them included. There is no difference in the most common table. So is it even needed to include the others?

KaneG_1-1601430999449.pngKaneG_2-1601431415631.png

 

 

AdhirKirtikar
7 - Meteor

I have yet to study spatial and reporting tools, but still managed to create a haphazard solution 😂

Next time will revisit again after learning these tools... 👨‍🎓

 

Spoiler
challenge_233_AdhirKirtikar.png

My noobie solution:

 

johnemery
11 - Bolide
Spoiler
Capture.PNG
JP_SDAK
8 - Asteroid

This was a good reporting and spatial challenge!  I had to modify to concatenate city,state before summarizing - I got different totals otherwise.  Turns out there's a Phoenix, OR and Las Vegas,NM. Who knew?

Spoiler
JP_SDAK_0-1602089121736.png

 

jamielaird
14 - Magnetar

Here's my solution:

 

Spoiler
jamielaird_0-1602337991932.png

jamielaird_1-1602338017334.png

 

 

LukaszKarpinski
8 - Asteroid

My solution below:

 

Spoiler
LukaszKarpinski_0-1602673143173.png

 

Steph_Maddrell
8 - Asteroid

Solution attached and screenshot below...

 

Spoiler
stephM_0-1602780779031.png

stephM_2-1602780925790.png

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution!

 

Spoiler
Hardest part for this one was figuring out the right thematic configuration for the Map 🙂
WeeklyChallenge233.JPG

Cheers!

NJ

randreag
11 - Bolide

Here my solution

SgdPackard810
8 - Asteroid

Fun challenge! Lots of different tools here: Spatial, Transform, Prep, and Reporting. Dope!