top of page
hand-businesswoman-touching-hand-artificial-intelligence-meaning-technology-connection-go-

Bump Chart in Tableau




BUMP CHART

Bump chart is a form of line chart designed for exploring changes in rank over period of time. This chart is normally used to compare the ranking of any dimension based on a particular measure value.


HOW TO BUILD A BUMP CHART IN TABLEAU?

This blog will detail how to make a bump chart using sample-Superstore data.

To create bump chart in Tableau, we are using two dimensions and one measure. In this dataset, we are using order date and region as dimensions and Sales as measure. Here I am analyzing the data only for the year 2021.


Image by author


For that, I am putting the order date into filters to get the data only for the year 2021.

Image by author


Here you can see the line chart for all the region by sales. Now, we want sales to show the ranking of the region. For this, select Rank in the quick table calculation as shown in the image below.

Image by author


Click on the compute using and region as shown.

Image by author


We will get sales by region and ranking is based on the sales.

Image by author


To make it look like a bump chart, we are duplicating the measure Sum(sales) as below. Also, we are changing the second output in circles.

Image by author


Dual chart is used for various purposes. Here we are using it for the purpose of formatting. Go to Dual axis to merge these two charts.

Image by author


Image by author


We can format our chart by changing the color and size.


We can also add ranks to the circles by the changing the alignment in the Label. Here, I am putting the ranks in the middle of the circles.


On completion of the above steps, we will get the bump chart as shown in the following image. It shows the variation of sales for each region over a period of time.

Image by author


Bump chart is built using ranks that displays the ranks on the chart itself.





259 views0 comments

Recent Posts

See All

Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
bottom of page