How to create Bump and Bubble Chart in Tableau

Last updated on Oct 21 2021
Ramnath Swami

Table of Contents

How to create Bump and Bubble Chart in Tableau

A bubble chart is visualizing the measures and dimensions in the form of bubbles.
A bubble chart is a group of circles. Each value of the dimension field represents the circles, and the value of measure represents the size of those circles.
The color of bubbles is set to differentiate the members present in a dimension. Here is the procedure to create a bubble chart as follows.
For example, consider a data source such as sample-superstore, and if you want to find the Profits for different Ship Mode. Then,
Step1: Drag the measures Profit and drop into the “Size” pane.
Step2: Drag the dimensions Ship Mode and drop into the “Labels” pane.
Step3: Also drag the dimension Ship Mode into the “Color pane” under the “Marks” card.

tableau 98
tableau

Bubble Chart with Measure Values

Also, you can show the value of the measures field that decides the size of the circles.
First, drag the measure Sales into the “Labels” pane. Show the following screenshot.

tableau 99
tableau

Bubble Chart with Measure Color

You can also use the same color with different shades for all the different size circles.
For this, drag the measure Sales into the “Color” pane. The darkest color shows the largest size of the circle and the lighter color shows the smallest size of the circle shown in the below screenshot.

tableau 100
tableau

Tableau Bump Chart

The bump chart is used to compare two dimensions using one of the measure value. It explores the changes in Rank of value over a time dimension or place dimension or any other relevant dimension.
The bump chart can take two dimensions with zero or more measures.
For example, consider a data source such as sample-superstore, if you want to find variations between the Ship Mode of the product and the Sub-Category.
Step1: Drag the dimension Sub-Category to the column shelf.
Step2: Drag the dimension Ship Mode to the color shelf.
By default, it creates the following view of the chart.

tableau 101
tableau

Step3: Create the calculated field.
1) Go to the Analysis and create a calculated field.
2) Give a field name to the calculated field such as Rank.
3) Write the expression “Index ()” in the calculated field calculation area. It creates an index for the current row in the partition.
4) Click on the OK button.

tableau 102
tableau

5) The new calculated field Rank will be visible in the Measure section.
6) Drag the Rank field to the row shelf.
7) Right-click on the Rank field and convert into “Discrete“.

tableau 103
tableau

After that, the following view appears that shows the dimension Sub-Category with each Ship Mode.

tableau 104
tableau

Step5: Apply some more calculations to the calculated field Rank using the measure Profit.
1) Right-click on the Measure Rank. And
2) Choose “Edit Table Calculation” option.

tableau 105
tableau

3) It opens the Table Calculation window.
4) Then, choose the “Specific Dimensions” option.

tableau 106
tableau

5) Select the Sub-Category field and Ship Mode field.
6) And, choose the sorting by the Profit field using partition by Sub-Category and addressed by Ship Mode.
The following view will appear shown in the below screenshot.

tableau 107
tableau

After completion of the all above steps, you will get the bump chart as shown in the below screenshot. It shows the variation of the Profit for each Ship Mode across different subcategories.

tableau 108
tableau

So, this brings us to the end of blog. This Tecklearn ‘How to create Bump and Bubble Chart in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau
• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface
Data Connection with Tableau Desktop
• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online
Basic Visual Analytics
• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets
Advanced Visual Analytics
• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering
Calculations in Tableau
• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations
Level of Detail (LOD’s) Calculations
Advanced Charts in Tableau
• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart
Parameters
• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line
Dashboards and Stories
• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points
Data Security in Tableau
Optimizations tips and tricks
Interacting with Tableau Server
Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

0 responses on "How to create Bump and Bubble Chart in Tableau"

Leave a Message

Your email address will not be published. Required fields are marked *