2020 Week 32: COVID-19 New Case Trends

Introduction

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.

Requirements

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.

Dataset

This week uses the COVID-19 data from Tableau’s COVID-19 Data Hub. Download the .hyper file from data.world

Attribute

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!

Calculation Assistance

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.

Solution

Watch