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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #233: The Truth Is Out There

KaneG
Alteryx
Alteryx

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
6 - Meteoroid

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
10 - Fireball
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

 

stephM
8 - Asteroid

Solution attached and screenshot below...

 

Spoiler
stephM_0-1602780779031.png

stephM_2-1602780925790.png

 

NicoleJohnson
14 - Magnetar
14 - Magnetar

My solution!

 

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

Cheers!

NJ

aruiz-itp
11 - Bolide

Here my solution

SgdPackard810
7 - Meteor

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