Hello! I’m not sure if this is the right place to ask, but I was given some feedback on my dashboard (https://public.tableau.com/views/UFOSightingsintheUS_17069361456020/Dashboard3?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link) to incorporate a metric that accounts for the population of each state to show sightings per capita instead of just highlighting areas with larger populations. I’m trying to get population data for the years 1990-2014, so I can create a map of the populations by state and then layer the number of sightings on top of this map.
However, I’ve been having an extremely difficult time doing this. I think I may be overthinking it, but I’ve tried to look for the data (Population by State) on the US Census website and haven’t been able to get any dataset for any of the years I want. I did find this dataset on GitHub, which I believe I can use (https://github.com/aaronpenne/data_visualization/blob/master/population/data/USA_Population_of_States_US_Census_Intercensal_Tables_1917-2017.csv) but from here, how do I create a map out of it and connect it to my UFO sightings data? This dataset also doesn’t get properly imported when I try to upload it in Tableau, so I’m also having that issue.
Sorry if any of this sounds confusing I can clarify if needed. I just don’t know what to do I’ve tried asking ChatGPT and looking through Reddit and Tableau Community, but I’m still lost and need to submit this dashboard today :/
Thank you!
submitted by /u/communityboyfriend
[link] [comments]
