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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

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

AYXAcademy
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.

Aaron_Harter
11 - Bolide

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

 

Blake
12 - Quasar

Why don't aliens celebrate holidays? 

 

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


233.png233report.png

 

atcodedog05
17 - Castor

Great challenge : )

atcodedog05_0-1600091825282.png

 

Hahaha

 

Spoiler
atcodedog05_0-1600091415519.png

 

Cheers and Happy Analyzing : )

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
233.png

Nice challenge.

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 233 is done!

 

Spoiler
challenge 233 JMS solution.PNG
PhilipMannering
14 - Magnetar
14 - Magnetar

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

 

Spoiler
ReportReportOutputOutput
ggruccio
13 - Pulsar
13 - Pulsar

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

 

phottovy
11 - Bolide

The truth is in either California or Florida apparently.

 

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