The Bump Chart is used to compare two dimensions of values against each other using one of the Measure value. The bump charts are very useful for exploring changes in the Rank of a value over a time dimension or place dimension or some other dimension relevant to the analysis.
The Bump Chart takes two dimensions with zero or more measures. I am using the Sample-superstore data source to demonstrate bubble chart, to find the variation of Ship mode of products with the variation of the Sub-Category.
Follow the below steps in the Tableau worksheet :
- Open Tableau and click on Connect to Data.
- Then the Connect page will open, click on Microsoft Excel.
- Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
- You can download a Sample Superstore.xls file from the link: https://chercher.tech/files/
- Once the data source has been connected, open a new worksheet by clicking on sheet1.
- The Sample Superstore excel file contains the below details.
- Drag and drop the dimension Sub-Category to the Columns shelf.
- Next, drag the dimension Ship mode to the Color shelf under the Marks card.
- And, leave the chart type to Automatic. The following chart appears.
- Next, create a calculated field called Rank.
- Go to Analysis:
- Select Create Calculated Field.
- Use Rank as the field name and write the expression Index() in the calculation area.
- It is an inbuilt function that creates an index for the current row in the partition.
- Click OK and the new field will be visible in the measures section.
- Right-click on the field Rank and Select convert it to discrete.
- Now drag the Rank measure to the row shelf, the following chart appears.