Workout Wednesday – Unemployment

I wasn’t feeling the Makeover Monday dataset for week three, so I did Workout Wednesday instead! (Love Emma’s approach of Trump v handlers tho!) The original required a worksheet for each state, which sounded *NOT FUN* so instead of sticking to the original challenge I got as close as possible using a single trellis chart. 

First I used dateparse on the years, and then created calculations for state and national unemployment rates. By fixing the national rate to the year, we can get them to appear on the same chart. (Note – remember that states have different populations, so don’t use the average of the state’s averages!)

Next I replicated the chart format using a single state. The line was simply the difference between state and national rates. Then I created a calculated field for the endpoint (if last() = 0 then [measure]) and added it via synchronized dual axis. Add a T|F calculation to color and you’re good to go. There was a lot of formatting. The pink shading was done using a reference band, and I used Times New Roman to approximate the original font. The trickiest part was getting the numbers to appear in the right format. ([Measure] > Default Properties > Number Format > Custom and then enter this: “+” #,##0.0%;”-” #,##0.0%;)

Finally, I built the small multiples grid. I had done this before with the lyrics makeover so this was a snap.

It was frustrating to not be in control of the headers, spacing, and axes of the small multiples. While it’s /possible/ to tweak these elements by creating separate worksheets, it isn’t practical or scalable. This is one of the few times I’ve felt truly limited in Tableau and would have preferred working in a platform with less structure and more control.


3 thoughts on “Workout Wednesday – Unemployment

  1. I am now not certain where you’re getting your info, but great topic. I needs to spend a while finding out much more or understanding more. Thanks for wonderful information I used to be on the lookout for this information for my mission.


  2. Great blog here! Also your web site lots up fast! What host are you the usage of? Can I get your affiliate link to your host? I wish my web site loaded up as quickly as yours lol


  3. Helpful information. Lucky me I found your web site by chance, and I am stunned why this coincidence did not happened earlier! I bookmarked it.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s