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