This week I wanted to post a WOW challenge derived from a chart I’ve been reporting on for the past 7 months: a cartogram of states showing rolling-seven day average of new COVID-19 cases by state. For this challenge you will use data from Tableau’s COVID-19 Data Hub. I picked this challenge because working with this data is extremely challenging. And I am hoping by creating this challenge participants will learn how to use the data and grow data fluency in working with COVID-19 data.
- Dashboard Size: 900px by 700px
- Use the People Positive Case Count field to calculate the new cases for each state for each day.
- Calculate the rolling seven-day new case counts for each state.
- Plot the seven-day average of newly reported COVID-19 cases by state.
- Be sure to add a line underneath each of the area trends.
- Label the maximum value for each state.
- Add a label for each state.
- Use 1 sheet.
- Format tooltips
- Match formatting.
This week uses the COVID-19 data from Tableau’s COVID-19 Data Hub. Download the .hyper file from data.world
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WOW2020 in your description to make it searchable!
To save time here are calculations to help create the cartogram
// Rows CASE [Province State Name] WHEN 'Alabama' THEN 7 WHEN 'Alaska' THEN 1 WHEN 'Arizona' THEN 6 WHEN 'Arkansas' THEN 6 WHEN 'California' THEN 5 WHEN 'Colorado' THEN 5 WHEN 'Connecticut' THEN 4 WHEN 'Delaware' THEN 5 WHEN 'District of Columbia' THEN 6 WHEN 'Florida' THEN 8 WHEN 'Georgia' THEN 7 WHEN 'Hawaii' THEN 8 WHEN 'Idaho' THEN 3 WHEN 'Illinois' THEN 3 WHEN 'Indiana' THEN 4 WHEN 'Iowa' THEN 4 WHEN 'Kansas' THEN 6 WHEN 'Kentucky' THEN 5 WHEN 'Louisiana' THEN 7 WHEN 'Maine' THEN 1 WHEN 'Maryland' THEN 5 WHEN 'Massachusetts' THEN 3 WHEN 'Michigan' THEN 3 WHEN 'Minnesota' THEN 3 WHEN 'Mississippi' THEN 7 WHEN 'Missouri' THEN 5 WHEN 'Montana' THEN 3 WHEN 'Nebraska' THEN 5 WHEN 'Nevada' THEN 4 WHEN 'New Hampshire' THEN 2 WHEN 'New Jersey' THEN 4 WHEN 'New Mexico' THEN 6 WHEN 'New York' THEN 3 WHEN 'North Carolina' THEN 6 WHEN 'North Dakota' THEN 3 WHEN 'Ohio' THEN 4 WHEN 'Oklahoma' THEN 7 WHEN 'Oregon' THEN 4 WHEN 'Pennsylvania' THEN 4 WHEN 'Rhode Island' THEN 3 WHEN 'South Carolina' THEN 6 WHEN 'South Dakota' THEN 4 WHEN 'Tennessee' THEN 6 WHEN 'Texas' THEN 8 WHEN 'Utah' THEN 5 WHEN 'Vermont' THEN 2 WHEN 'Virginia' THEN 5 WHEN 'Washington' THEN 3 WHEN 'West Virginia' THEN 5 WHEN 'Wisconsin' THEN 3 WHEN 'Wyoming' THEN 4 END
// Columns CASE [Province State Name] WHEN 'Alabama' THEN 8 WHEN 'Alaska' THEN 1 WHEN 'Arizona' THEN 3 WHEN 'Arkansas' THEN 6 WHEN 'California' THEN 2 WHEN 'Colorado' THEN 4 WHEN 'Connecticut' THEN 11 WHEN 'Delaware' THEN 11 WHEN 'District of Columbia' THEN 10 WHEN 'Florida' THEN 10 WHEN 'Georgia' THEN 9 WHEN 'Hawaii' THEN 1 WHEN 'Idaho' THEN 3 WHEN 'Illinois' THEN 7 WHEN 'Indiana' THEN 7 WHEN 'Iowa' THEN 6 WHEN 'Kansas' THEN 5 WHEN 'Kentucky' THEN 7 WHEN 'Louisiana' THEN 6 WHEN 'Maine' THEN 12 WHEN 'Maryland' THEN 10 WHEN 'Massachusetts' THEN 12 WHEN 'Michigan' THEN 9 WHEN 'Minnesota' THEN 6 WHEN 'Mississippi' THEN 7 WHEN 'Missouri' THEN 6 WHEN 'Montana' THEN 4 WHEN 'Nebraska' THEN 5 WHEN 'Nevada' THEN 3 WHEN 'New Hampshire' THEN 12 WHEN 'New Jersey' THEN 10 WHEN 'New Mexico' THEN 4 WHEN 'New York' THEN 10 WHEN 'North Carolina' THEN 8 WHEN 'North Dakota' THEN 5 WHEN 'Ohio' THEN 8 WHEN 'Oklahoma' THEN 5 WHEN 'Oregon' THEN 2 WHEN 'Pennsylvania' THEN 9 WHEN 'Rhode Island' THEN 11 WHEN 'South Carolina' THEN 9 WHEN 'South Dakota' THEN 5 WHEN 'Tennessee' THEN 7 WHEN 'Texas' THEN 5 WHEN 'Utah' THEN 3 WHEN 'Vermont' THEN 11 WHEN 'Virginia' THEN 9 WHEN 'Washington' THEN 2 WHEN 'West Virginia' THEN 8 WHEN 'Wisconsin' THEN 8 WHEN 'Wyoming' THEN 4 END
After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @AnnUJackson, @LukeStanke, @_Lorna_Brown and @IvettAlexa.