How To: Using Ranks to Create Bump Charts in Tableau

3/17/2016 Matt Chambers 14 Comments



I saw a really cool analysis done by Datagraver on the popularity of car colors over time.  I built this viz as a way to reimagine what they had done.

Check out the interactive version

This viz exploded in popularity after posting it on reddit/r/dataisbeautiful to the tune of 300k+ views.  I certainly didn't expect this for such a simple viz, but I am glad that it resonated with so many.

One thing I noticed in the comments on Reddit is that people were curious about how to do this in Tableau.  It is pretty simple to build bump charts in Tableau, so let's look at what it takes to build them.

Step 1: Create a calculated field for the measure we want to rank.  In this case, I am using rank_unique so that the same rank isn't assigned.



Step 2: Bring the dimension you are ranking by to the color shelf and pull the Year or time period to the columns shelf.



Step 3: Bring the newly created Rank measure to the rows shelf.  Change the Compute Using to whatever your dimension is on the color shelf.  This will give you a basic bump chart.


Step 4: To get the ranks on the bump chart itself, I use dual axis.  Drag another copy of your rank to the rows, select the same compute using, and then select dual axis.  Make sure to synchronize your axes.


Step 5: Change the marks on the secondary axis to circles.


Step 6: To display the ranks on the circles, we need a calculated field to convert them to a string.  We create this and then add it to the labels.  Make sure to compute by the dimension specified for the rank.



Step 7: Reverse the axis.




That's it!  You now have a bump chart built using ranks that displays the ranks on the chart itself.

Feel free to download the workbook and comment with any questions.

14 comments:

  1. Awesome. super easy and straight forward.

    ReplyDelete
    Replies
    1. Divine Loan Opportunity Offered By CHESTER BRIAN LOANS That Save My Family From Financial Bondage {Brianloancompany@yahoo.com }

      Hello Everyone, I am Rosie Rhoma a single mom from Texas USA, I will like to share this great testimony on how i got a loan from Chester Brian Loans, when we were driven out of our home when i couldn't pay my bills anymore, After been scammed by various companies online and denied a loan from my bank and some other credit union i visited. my children were taken by the foster care, i was all alone in the street. Until a day i shamefully walked into an old school mate who introduced me to Daisy Maureen. At first i told her that i am not ready to take any risk of requesting a loan online anymore, but she assured me that i will received my loan from them. On a second thought, due to my homelessness i had to take a trial and applied for the loan, luckily for me i received a loan of $80,000.00 from Chester Brian Loans. Am happy i took the risk and applied for the loan. my kids have been given back to me and now i own a home and a business of my own. All thanks and gratitude goes to CHESTER BRIAN LOAN COMPANY for giving a meaning to life when i had lost all hope. If you currently seeking for a loan assistance, you can contact them via: {Brianloancompany@yahoo.com } OR text (803) 373-2162 and also contact there webpage via brianloancompany.bravesites.com

      Delete
  2. This is awesome. I try to download the workbook but since my version is 9.1, it can't open it on my machine. I can get the graph, but I noticed once we hover over any circle, it will highlight all the circles for that color category, I can't do this. Could you please tell me how to get this? Or is that just because 9.1 can't do that? Thanks so much

    ReplyDelete
  3. Just wish to say your article is as surprising.

    The clarity to your post is simply great and that i could
    suppose you’re a professional on this subject.
    Well with your permission let me to clutch your feed to stay up to date with approaching post.

    Thank you a million and please continue the rewarding
    work.
    Tableau Guru
    www.sqiar.com

    ReplyDelete
  4. How to change color border on hover action in Tableau Public?

    Thanks
    Matjaz

    ReplyDelete
    Replies
    1. You will need to create a dashboard action for a highlight on hover.

      https://onlinehelp.tableau.com/current/pro/online/mac/en-us/actions_highlight_advanced.html

      Delete
  5. Awesome tutorial Matt. We have a retailer that is presenting at TC16 and one of their visualizations is a derivative of this viz. Thanks to talented people like yourself, you are helping to shape how people see and understand their data. In Tableau 10, I had to check the "Allow labels to overlap other marks" and then had to set the alignment to center. The default for me was the rank was to the right of the mark. Just wanted to add this for those that may encounter the same thing. Awesome tutorial!

    ReplyDelete
  6. Replies
    1. Divine Loan Opportunity Offered By CHESTER BRIAN LOANS That Save My Family From Financial Bondage {Brianloancompany@yahoo.com }

      Hello Everyone, I am Rosie Rhoma a single mom from Texas USA, I will like to share this great testimony on how i got a loan from Chester Brian Loans, when we were driven out of our home when i couldn't pay my bills anymore, After been scammed by various companies online and denied a loan from my bank and some other credit union i visited. my children were taken by the foster care, i was all alone in the street. Until a day i shamefully walked into an old school mate who introduced me to Daisy Maureen. At first i told her that i am not ready to take any risk of requesting a loan online anymore, but she assured me that i will received my loan from them. On a second thought, due to my homelessness i had to take a trial and applied for the loan, luckily for me i received a loan of $80,000.00 from Chester Brian Loans. Am happy i took the risk and applied for the loan. my kids have been given back to me and now i own a home and a business of my own. All thanks and gratitude goes to CHESTER BRIAN LOAN COMPANY for giving a meaning to life when i had lost all hope. If you currently seeking for a loan assistance, you can contact them via: {Brianloancompany@yahoo.com } OR text (803) 373-2162 and also contact there webpage via brianloancompany.bravesites.com

      Delete
  7. Well this is such a beautiful post for a car lover like me. Would love to see such more articles from you. Thanks for sharing it with us..

    ReplyDelete
  8. Hey! Thanks a lot for this..I have a question.I don't see the option of dual axis when I drag color rank into rows. Can you help me understand why? Please? Thanks a lot!

    ReplyDelete
  9. great nice your blog thank for sharing.
    goldenslot

    gclub online

    ReplyDelete
  10. Divine Loan Opportunity Offered By CHESTER BRIAN LOANS That Save My Family From Financial Bondage {Brianloancompany@yahoo.com }

    Hello Everyone, I am Rosie Rhoma a single mom from Texas USA, I will like to share this great testimony on how i got a loan from Chester Brian Loans, when we were driven out of our home when i couldn't pay my bills anymore, After been scammed by various companies online and denied a loan from my bank and some other credit union i visited. my children were taken by the foster care, i was all alone in the street. Until a day i shamefully walked into an old school mate who introduced me to Daisy Maureen. At first i told her that i am not ready to take any risk of requesting a loan online anymore, but she assured me that i will received my loan from them. On a second thought, due to my homelessness i had to take a trial and applied for the loan, luckily for me i received a loan of $80,000.00 from Chester Brian Loans. Am happy i took the risk and applied for the loan. my kids have been given back to me and now i own a home and a business of my own. All thanks and gratitude goes to CHESTER BRIAN LOAN COMPANY for giving a meaning to life when i had lost all hope. If you currently seeking for a loan assistance, you can contact them via: {Brianloancompany@yahoo.com } OR text (803) 373-2162 and also contact there webpage via brianloancompany.bravesites.com

    ReplyDelete