Author: graphhopperblog

# Makeover Monday – Over/Undertourism

This week's #MakeoverMonday challenge looks into countries where tourists greatly outnumber locals, or vise versa. Original:  I like the original, but I think the transition between Mexico, Italy, and Spain from more locals to more tourists is hard to understand at a glance. If the sample was more balanced, it might be easier to quickly understand … Continue reading Makeover Monday – Over/Undertourism

# Makeover Monday – Bee Colony Loss

This week's #MakeoverMonday challenge is visualizing bee colony loss in the United States. Original: I like the filled map and color choices, but was curious about trends over time - which can be difficult to see on a map. Because there aren't obvious regional trends, a line chart could be more insightful. Makeover: How-To: First, get … Continue reading Makeover Monday – Bee Colony Loss

# Index Sort Order

Sometimes you really need to see the top n values in different categories, which is surprisingly tricky in Tableau! Here's a quick guide to doing that with index().       For Compute Using select Specific Dimensions For this example, check all field names under Specific Dimensions to avoid partitioning the data. Unchecking [Abilities] at … Continue reading Index Sort Order

# Quick tip – Combined fields

Suppose you have a chart like this, and someone asks you to make the panes two different colors. You could add the dividing measure (State here) to color, but that would remove the measure already there. What to do? Make a combined field! Add the new field to color, adjust your table calculations, and you're … Continue reading Quick tip – Combined fields

# Move Like a Nerd

Big news everyone, I'm starting a new job across the country next month! Naturally, when packing I wanted to keep everything organized with as little work as possible. Here's what the packing process looks like: pack a box slap 4 matching barcodes onto it (top and 3 sides) scan the barcode with my phone log a … Continue reading Move Like a Nerd

# Makeover Monday – Revenue per Second

This week's #MakeoverMonday looks at revenue per second for 25 of the biggest companies. Initial Thoughts The circular orientation of the chart is super misleading! Normally, the angle of the stopwatch would represent time, so on this chart my very first impression is that everything adds up to 45 seconds, which is completely false. If … Continue reading Makeover Monday – Revenue per Second

# Oscars!

My family is strangely obsessed with the Oscars, and every year I wind up making my own spreadsheet of Oscar Nominees, because I can never find a pre-made one. This year I posted it to data.world, and it was chosen as a featured data set! . . . . Here's a peak at what I … Continue reading Oscars!