Weekly Challenge

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

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

Submit Feedback
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.

Challenge #233: The Truth Is Out There

Highlighted
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: https://en.wikipedia.org/wiki/Unidentified_flying_objectSource: https://en.wikipedia.org/wiki/Unidentified_flying_object

 

Unidentified Flying Objects – also known as UFOs are exactly what they sound like. We tend to associate them with extraterrestrial activity but many sightings are attributed to covert military activity, like trying out new planes! Whether you believe they are signs that we aren’t alone or chalk them up to rogue weather balloons, the fact remains that many people around the world report sightings every year.

 

This week’s challenge includes a dataset with reported sightings across the USA and a second dataset with some details around the cities. Use these datasets to create a map showing the locations of sighting from 2019, and a table with the 25 most active cities over the dataset, including the most active year for each of those cities and the number of sightings that occurred in that active year.

Highlighted
Alteryx Certified Partner

Fun challenge to start the week!

Spoiler

233.1.PNG

 

233.2.1.PNG

 

ID.gif

 

 

(edit 9/14 10:12 CT) video of solution overview:

Spoiler

 

Highlighted
Alteryx Certified Partner

Why don't aliens celebrate holidays? 

 

Spoiler
They don't like to give away their presence. 


233.png233report.png

 

Highlighted
12 - Quasar

Great challenge : )

atcodedog05_0-1600091825282.png

 

Hahaha

 

Spoiler
atcodedog05_0-1600091415519.png

 

Cheers and Happy Analyzing : )

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
233.png

Nice challenge.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 233 is done!

 

Spoiler
challenge 233 JMS solution.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Solution below. I tried splitting off Hawaii and Alaska for slightly better visibility.

 

Spoiler
ReportReportOutputOutput
Highlighted
12 - Quasar
12 - Quasar

Fun!  Although I had the same count for 2008 for San Diego and LA as in 2007, I just uniqued them to get the one value.

 

Spoiler
ggruccio_0-1600102143003.pngggruccio_1-1600102174077.png

 

Highlighted
8 - Asteroid

The truth is in either California or Florida apparently.

 

Spoiler
233.PNG
Highlighted
8 - Asteroid
Spoiler
Spalders_0-1600104899600.png