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

kelvin_law1
9 - Comet

Here are my solution & output:

Spoiler
kelvinlaw_1-1600402949458.png

kelvinlaw_3-1600403070666.png

 

JonathanAllenby
8 - Asteroid

My solution:

Spoiler
JonathanAllenby_0-1600429549364.png

 

JonathanAllenby_0-1600429954769.png

 

 

dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1600450764261.png
dsmdavid_0-1600450954353.png

 

 

 

kelly_gilbert
13 - Pulsar

Another great chance to practice with reporting tools! I took a few liberties with the report output, such as changing the alignment and creating bubble maps.

 

The original solution:

 

Spoiler

Generating the top-25 table. I added handling for years that tied. I also added a title and changed the alignment of the year column, so it didn't run into the sighting count.
challenge_233_01 - top 25 table.PNG


Generating the original map. I wanted to make this dyanamic, so it finds the last full year (at least 10 months) present in the data. I also found a large number of cities (334) that were not in the US Cities file, however, they all had <= 3 total sightings.

challenge_233_02 - original map.PNG


Finally, assembling the report:



challenge_233_03 - assemble final report.png

 

 

I had a hard time gaining insights from the original map, given the large number of different UFO shapes (colors). Also, if the same lat/lon had multiple sightings, the dots overlapped (so you couldn't see the different colors). I think the primary questions you would want to answer with a map are 1) are there geographic hotspots for sightings in general? 2) are there geographic hotspots for certain shapes?

To answer those questions, I tried making some bubble maps.

 

Spoiler
Bubble map of total sightings:

challenge_233_04 - bubble map overall.PNG

challenge_233_04 - workflow.PNG


Regional density per shape:
challenge_233_06 - grid.PNG

challenge_233_05 - workflow.PNG

This could be a lot better/more sophisticated, e.g. show sightings per capita, more meaningful radius calculation, etc. However, it does give me a little more insight into the geography of sightings.
mbogusz
9 - Comet
Spoiler
2020-09-19 07_53_26-Greenshot.png
Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1600652523006.png

 

DataNexus
7 - Meteor

Ok, lets try posting this to the correct thread this time.

 

Hi everyone, this is pretty much my first workflow built in Alteryx except small basic filtering. If anyone has any pointers, would love to hear them.

 

See you next challenge

 

Spoiler
DataNexus_0-1600662203506.png

 

Sudha8990AI
8 - Asteroid

Good Exercise - After a long time.

mmkisaac
8 - Asteroid

Fun