Recently, I came across one of the Workouts Wednesday Challenges which is a bump chart in a unique way. In this blog, I will demonstrate how to create a Bump chart. Then you can give it a go with the above challenge.

A bump chart is one of the effective ways to show the ranking variations of a dimension over the time dimension or other dimensions based on the analysis. It is easy and quick. All you need to do is create two different charts using line and circle mark type by using rank calculation and overlay the charts using the dual-axis method.

For this task, I am going to use the superstore dataset and aim to find the ranks of regions from quarter to quarter based on total sales.

Step 1: Right Click the Order Date and drag it into columns and select Quarter. Then Drag the Sales into columns. Lastly, drag the regions into color.

Step 2: Right Click on the Sum of Sales pill in the row -> Select Quick Table Calculation -> Select Rank.

To create Rank by Region, Right click on the Sum of Sales pill -> Select Edit Table Calculation – > Select calculation type as Unique -> Select Specific Dimensions in Compute Using -> Tick Region.

Step 3: Reverse the Rank of Sales Axis. Double click on Rank of Sales Axis -> Select Reversed in Scale.

(This will Reverse the axis and show the rank in ascending order)

Step 4:  Duplicate the Sum of Sales pill and Select the mark type as Circle on the second marks card.

Step 5: Right Click on Sum of Sales pill in row -> Select Dual Axis. Then Right Click on Rank of Sales -> Select Synchronize Axis.

Step 6: Select the Second chart -> Tick Show Mark Labels -> Select the Alignment as shown below.

Step 7: Remove the Right and top headers by Right click -> untick show header

Finally, you can have a simple and easy bump chart in your dashboard. I hope this blog helped you to build your Bump chart.