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