Visualising Fatalities Rate of Measles in US across the years


#1

Hi, I am Swansea University Student and I am currently working on data visualisation coursework that involves visualising data from Ptycho. Below are my visual design and it’s details


DOI: 10.25337/T7/ptycho.v2.0/US.14189004
Tool: Tableau
Type of Visual Design: Choropleth Map
Country: United State
Year: 1888 - 1908

Visual Mapping:

  • Color: Blue color map to sum of count value of Measles in USA states, the deeper the color the greater the sum of count value. Yellow and Gold colors indicate the fatality rate of Measles in USA states. The deeper gold indicates the higher rate of fatalities otherwise lower.
  • Shape: Circles on the map indicates the fatalities rate of a province.
  • Map: States in United State.
  • Label: Name of the state.
  • Tooltip: show all information includes name of the state, num of the cases, num of fatalities, and fatalities rate.

Data Preparation: to calculate the fatalities rate, I have summed up the number of the fatalities and divided by the sum of the count value and times 100 (convert it into percentage). I have filter out non-sense data for such as state that named NA.

Description:
The image above shows the fatality rate over the number of infected people of Measles in the USA states from the years 1888 to 1908.

Unique Observation:
From the image above we can see that Pennsylvania has the highest sum of Measles Cases and Alabama has the highest fatalities rate.

Question:
During visualising the data, I have realised the fatal rate and the total infected patients are higher at the beginning of the years [between years 1888 to 1904] and it decreased after 1905. Hence, I am trying to create Small Multiple Choropleths so I can show more information in my visual design. I have seen the post [Visualising time on a geospatial map] and also trying to follow the video provided by SIM but it doesn’t work for the map. I have referred to one of the Tableau forum (i lost the forum link) and now I able to show the decades of years as row but not able to filter out the year that belong to the decade at the column What I have done so far. I am looking for help to show the only years that belongs to its decade.

Litreture: this blog https://bl.ocks.org/armollica/6314f45890bcaaa45c808b5d2b0c602f by Andrew Mollica inspired me to use of Small Multiple Choropleth Map.

Thanks in advance.

**Had remove one of the link coz it doesn’t allow me to post 2 link in one post


#2

IMHO, I feel that multiple small map might not be suitable for your case after looking at the link you provided above. It will cause the map being to small to be viewed. Instead, it is better to let user able to interact with it or you may consider to make a video to show the changes over the years.


#3

I’m not able to help you with technical point about filtering columns. However, I would aggregate the data by decade rather than showing individual columns. Instead I would use the columns to show different aspects of the data (infection cases, fatality count, fatality rate). Might also be interesting to show the population of the state if you have that data. Also, I think the legend text could use some reworking.