As a sales analyst, I was working on analyzing the monthly regional sales performance for the current year. I had to visualize the data in such a way that I could see the sales in the region month by month.
Along with this, I also wanted to add one more data metric in the Tableau visualization, which was the ranking of sales in the specific region for each month throughout the year.
For this data visualization, I created a Bump Chart in Tableau. In this chart, using the data points, I was able to visualize the sales rank of each region over the months in the year.
In this tutorial, I will explain the Tableau Bump Chart and how to create one to visualize the data in Tableau.
What is a Tableau Bump Chart?
In Tableau, the Bump Chart is used to display the changes in rank of different categories over time. The bump chart in Tableau is a combination of a line chart and a circle chart.
The circles in the Tableau bump chart display the ranks of the category, for example, the sales rank of a region for a specific month. The lines in the bump chart connect the circles (points) for each category across the timeline (months, quarters, or years), showing how the rank changes over time.
Create a Tableau Bump Chart
To create the bump chart, we will use the Tableau Superstore dataset. Connect the data source with Tableau and follow the steps below to create a Bump Chart in Tableau.
- In the superstore dataset, we have data from current and previous years. To get the data for the current year, drag the Order date to the Filters and select the current year check box.
- To compare the sales over the current year months, I will add the Order Date to the Rows. By default, the order date is in year format. To change this, click on the dropdown and select Month.
- To show sales for the month, add the Sales(SUM) to the Columns. After this, distribute the sales by region. For this, add Region to the Color card in the Marks section.
- Next, click on Sales in the rows again and select Quick Table Calculation > Rank.
- To rank the sales according to Region, click on Sales in rows and select Compute Using > Region.
- Now, the line chart will show the monthly sales for each region. To add data points for months on the region sales, press “Ctrl” and duplicate the Sales by dragging it in Rows.