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.
alteryx Community

# 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

8 - Asteroid

Here are my solution & output:

Spoiler

8 - Asteroid

My solution:

Spoiler

11 - Bolide
Spoiler

12 - Quasar

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.

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.

Finally, assembling the report:

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:

Regional density per shape:

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.
8 - Asteroid
Spoiler
14 - Magnetar

Here is my solution !

8 - Asteroid
Spoiler
Solution Attached

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

8 - Asteroid

Good Exercise - After a long time.

8 - Asteroid

Fun