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
Author: graphhopperblog
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!
Makeover Monday – Meat
This week's #MakeoverMonday challenge is about the yearly pounds per capita consumption of various meat products. The original chart is a line graph showing pork, beef and chicken consumption by year. Initial Thoughts Labeling every two years is busy, 5 or less would be better The colors for Pork and Chicken are similar, while the … Continue reading Makeover Monday – Meat
Looking Back
It's been just over a year since I started Graphhopper Blog, and what a year it has been! Since October 2016 there have been: 35 blog posts 28 GitHub contributions 20 Makeover Monday challenges 21 Tweets 7 Edx courses completed 1 Tableau Conference (Thanks work!) My favorite creation is an early one - Makeover … Continue reading Looking Back
Makeover Monday – Christmas Trees
It's Makeover Monday time again! This week's original comes from Statista, and shows Millions of Dollars spent on Christmas trees in the United States, partitioned by year and tree type. In my makeover, I took the original stacked bars, and turned that view into a line chart tracking overall tree sales. Then I added a … Continue reading Makeover Monday – Christmas Trees