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.