How to make a bump chart in Tableau (with a side of politics)

 

Finished product

 

Recently the Netherlands held their general elections. This was a tense time of year for me, having watched the UK vote to leave the EU and seeing Trump become president. Maybe I’m a bit of a hippie or an idealist, but I am not very much a fan of the current popular xenophobic opinions. Sure, the world is going through some uncertain times, but wouldn’t it be better if we just worked together?

I thought I’d have a look to see how the political climate has changed in The Netherlands over time. The results I found still a little alarming, the, what some may call the “racist” PVV party, has gone up in rankings, but luckily, has not reached the top!

Enough of that, it’s time to viz. So what I wanted to do with my viz, was see how each of the political parties ranked over the years. I got my data from the almighty Wikipedia. They have a page for each election year, showing how many seats each party has won. I copied and pasted these into an excel file. Simples!

Now to make the bump chart:

  1. Bring the measure (or dimensions) you want to splits your ranks by (in my case the year) to columns as a discrete field.
  2. Bring the field containing the members you want to rank to colours. In my case this is the ‘Party’.

steps 1 and 2

  1. To apply the ranking, you will need to create a calculated field for the measure you want to rank. To do this I’ve used the Rank Unique function.

 

Step 3

  1. Bring this new rank field to the rows shelf. This will look a little messy to start with.
  2. You now need to change the ‘Compute Using’ to your dimension of choice, which for me is ‘Party’. In case you aren’t sure how to do this, click on the triangle on the right-hand side of your rank pill and select, compute using, then your field.

step 4

  1. Almost there! To create the “bumps” you will need to make this a dual axis chart and change one of your marks to a circle. Done!

 

step 6

  1. Format etc. to your liking!

See the final viz here!

One thought on “Bump Charts

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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