#WOW2020 week 35 | Can you build a bivariate map?

Introduction

Hi friends! Well, it’s been a quarter since my last challenge so you know what that means, it means we’ve got a new version of Tableau to check out! A couple weeks ago, 2020.3 was released and with it came a whole host of new awesome features and functionality! As always, #WOW2020 is here to help you get familiar with a couple of those new features. 

The Features
One of the best things to come out of this new version is ability to relate two logical tables together via a calculation. This is very similar to join calculations but work with noodles!

The other feature/enhancement we’ll be checking out is the ability to easily create a default value for a parameter when we clear our selection. Tableau Zen Master, Kevin Flerlage wrote a great article about this feature last week. Feel free to check it out to help you along!

The Challenge
MAPS!!! Everyone loves ’em but they can be a bit intimidating so we’re going to be work on that with one of my favorite map charts. Bivariate maps allow for analyzing a single dimension against two measures quickly and easily. A bivariate map is essentially a mashup of two maps with two color scales. For this challenge, we’re going to be looking at the historical unemployment rates between 2000 and 2019 compared to the median household income for 2018 only for every county in the country.

And for funsies, I threw in a custom color legend too!

Requirements

  • Dashboard Size: Generic Desktop
  • # of Sheets – up to you
  • Relate the Lookup Table to the 2 fact tables
    • FIPS code is a concatenation of State code and county code
  • Create a county-level map 
    • exclude Puerto Rico
  • Compare the county level measures to the 25th and 75th percentile values for each measure
    • Low is <= 25th percentile
    • Medium is between 25th and 75th percentile
    • High is above 75th percentile
  • Create a year list for users to click to filter
  • Create a KPI card on the left side bar
  • Create a custom 9-box legend in the upper right corner
  • Colors
  • Match Tooltips

Dataset

This week uses three custom tables. You can get it here at 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!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @AnnUJackson@LukeStanke, @_Lorna_Brown and @HipsterVizNinja

Solution

Interactive

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top