How to Create Tableau Bump Chart?
A Bump Chart shows a comparison between two dimensions using a measure of your choice. It is a line chart which is used when we want to explore the changes in a rank of value over a period of time or place dimension or some other dimension relevant to the analysis or based on any other dimension of your choice. The Bump Chart proceeds by taking two dimensions with zero or more measures.
Creating a Bump Chart
To create a treemap, the following are the steps:
- Open the Tableau Desktop and connect to your data source.
- Drag and drop your dimension(created Time) to the Columns shelf. Right click on it and choose the month option. The following chart appears.
- Next, we need another dimension. So grab your dimension (we have taken direction) and place it under color label. You will notice the resulting chart.
- From the chart option, present under the marks card, choose the line chart option.
- Drag and drop the measured field (we have taken sales) to the rows shelf. You will observe the resulting line chart.
- Now, we will rank the above view based on the sales revenue measure. To achieve, right click on the Sales measure field. A drop-down menu will occur.
- Choose the quick table calculation → choose Rank field. It is an inbuilt function that creates an index for the current row in the partition.
- Tableau will rank sales based on monthly sales. The following chart will appear where the lines are created, and the color represents the directions.
- Right-click on the measured field and convert it to discrete. The following chart appears.
- We can apply some more sorting to the rank field. Right click on the Sales measure. Choose Edit Table calculation.
- A box menu will appear. We can change the order from descending to ascending.
- The following screenshot shows the calculations applied.