Introduction
While reviewing recent work I’ve done in preparation for this week’s challenge, I came across a tile map with individual area charts by state that we use to monitor subscriptions, and thought it would be a fun one. As I dug into it, I realized it was inspired by Luke’s challenge in 2020 Week 32. But it’s been a minute since then, and I actually used LODs where Luke used Table Calculations, so we’re going to revisit (or perhaps try for the first time) area chart tile maps this week.
Requirements
- Dashboard size: 1300 x 800
- Create a standardized area chart showing population by year (you’ll need to multiply the population value by 1000) relative to the min/max of each state.
- Show the state and most recent population in the label
- Create a bar chart showing the most recent population by state. When hovering over a bar, it should highlight the state in the tile map
- Match tooltips
Dataset
This week’s data is population by state by year from the FRED (Federal Reserve Economic Data). I’ve done some cleanup and pivoting, so you can find the file here. Don’t forget to reference the FRED site on your viz.
Calculation Assistance
To save some time, here are a couple calculations for the tile map.
//Rows
CASE [State]
WHEN 'AL' THEN 7
WHEN 'AK' THEN 1
WHEN 'AZ' THEN 6
WHEN 'AR' THEN 6
WHEN 'CA' THEN 5
WHEN 'CO' THEN 5
WHEN 'CT' THEN 4
WHEN 'DE' THEN 5
WHEN 'DC' THEN 6
WHEN 'FL' THEN 8
WHEN 'GA' THEN 7
WHEN 'HI' THEN 8
WHEN 'ID' THEN 3
WHEN 'IL' THEN 3
WHEN 'IN' THEN 4
WHEN 'IA' THEN 4
WHEN 'KS' THEN 6
WHEN 'KY' THEN 5
WHEN 'LA' THEN 7
WHEN 'ME' THEN 1
WHEN 'MD' THEN 5
WHEN 'MA' THEN 3
WHEN 'MI' THEN 3
WHEN 'MN' THEN 3
WHEN 'MS' THEN 7
WHEN 'MO' THEN 5
WHEN 'MT' THEN 3
WHEN 'NE' THEN 5
WHEN 'NV' THEN 4
WHEN 'NH' THEN 2
WHEN 'NJ' THEN 4
WHEN 'NM' THEN 6
WHEN 'NY' THEN 3
WHEN 'NC' THEN 6
WHEN 'ND' THEN 3
WHEN 'OH' THEN 4
WHEN 'OK' THEN 7
WHEN 'OR' THEN 4
WHEN 'PA' THEN 4
WHEN 'RI' THEN 3
WHEN 'SC' THEN 6
WHEN 'SD' THEN 4
WHEN 'TN' THEN 6
WHEN 'TX' THEN 8
WHEN 'UT' THEN 5
WHEN 'VT' THEN 2
WHEN 'VA' THEN 5
WHEN 'WA' THEN 3
WHEN 'WV' THEN 5
WHEN 'WI' THEN 3
WHEN 'WY' THEN 4
END
//Columns
CASE [State]
WHEN 'AL' THEN 8
WHEN 'AK' THEN 1
WHEN 'AZ' THEN 3
WHEN 'AR' THEN 6
WHEN 'CA' THEN 2
WHEN 'CO' THEN 4
WHEN 'CT' THEN 11
WHEN 'DE' THEN 11
WHEN 'DC' THEN 10
WHEN 'FL' THEN 10
WHEN 'GA' THEN 9
WHEN 'HI' THEN 1
WHEN 'ID' THEN 3
WHEN 'IL' THEN 7
WHEN 'IN' THEN 7
WHEN 'IA' THEN 6
WHEN 'KS' THEN 5
WHEN 'KY' THEN 7
WHEN 'LA' THEN 6
WHEN 'ME' THEN 12
WHEN 'MD' THEN 10
WHEN 'MA' THEN 12
WHEN 'MI' THEN 9
WHEN 'MN' THEN 6
WHEN 'MS' THEN 7
WHEN 'MO' THEN 6
WHEN 'MT' THEN 4
WHEN 'NE' THEN 5
WHEN 'NV' THEN 3
WHEN 'NH' THEN 12
WHEN 'NJ' THEN 10
WHEN 'NM' THEN 4
WHEN 'NY' THEN 10
WHEN 'NC' THEN 8
WHEN 'ND' THEN 5
WHEN 'OH' THEN 8
WHEN 'OK' THEN 5
WHEN 'OR' THEN 2
WHEN 'PA' THEN 9
WHEN 'RI' THEN 11
WHEN 'SC' THEN 9
WHEN 'SD' THEN 5
WHEN 'TN' THEN 7
WHEN 'TX' THEN 5
WHEN 'UT' THEN 3
WHEN 'VT' THEN 11
WHEN 'VA' THEN 9
WHEN 'WA' THEN 2
WHEN 'WV' THEN 8
WHEN 'WI' THEN 8
WHEN 'WY' THEN 4
END
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 #WOW2024 in your description to make it searchable!
Share
After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2024 #Tableau and tag @WorkoutWednsday
Solution
Interactive
