How to create Dual Axis Chart, Box Plot and Heat Map in Tableau

Last updated on Oct 21 2021
Ramnath Swami

Table of Contents

How to create Dual Axis Chart, Box Plot and Heat Map in Tableau

Tableau Dual Axis Chart

The dual axis chart is used to visualize two different measures in two different chart types. A date column and two measures are necessary to build a dual axis chart.
The different scales are used in the graph that helps the user to understand both measures. The procedure to create a dual axis chart is given step by step below.
For example, consider a data source such as Sample-Superstore and its measures and dimensions.
Step 1: Go to the worksheet.
Step 2: Hold the Ctrl key in the keyboard.
Step 3: And select the dimension OrderDate, measures Sales and Quantity as shown in the below screenshot.

tableau 119
tableau

Step 4: Click on “Show Me” option located on the top right corner of the worksheet.
Step 5: Select the “dual combination” icon, as shown in the below screenshot.

tableau 120
tableau

After completion of above all steps, it creates the dual axis chart as shown in the below screenshot.

tableau 121
tableau

Tableau Box Plot

The box plot is also called the box-and-whisker plots. They show the distribution of value along an axis.
All box indicates the middle 50 percent of the data where the middle two quartiles of the data’s distribution. On both sides, the remaining 50 percent of data represents by lines called whiskers.
To display all points within 1.5 times of interquartile range, which is all aspects within 1.5 times of the width of the adjoining box, or all points at the maximum area of the data.
The Box Plot takes one or more measures with zero or more dimensions.
For example, consider the data source such as Sample-Superstore and find the size of Profits field for the dimension Category for each ShipMode field values. Below are the steps to create a box plot.
Step 1: Drag the dimension Category and drop into the Columns shelf.
Step 2: Drag the measure Profit and drop into the Rows shelf.
Step 3: Also drag the dimension ShipMode and drop into the right of the Category field in the Columns shelf.

tableau 122
tableau

Step 4: Choose the Box-and-Whisker plot from “Show Me”.

tableau 123
tableau

The below chart appears that shows the box-and-whisker plot.Automatically Tableau reassigns the ShipMode to the Marks pane.

tableau 124
tableau

Tableau Heat Map

The heat map is used to visualize the data in the form of size and color on different measures.
Two different measures are visualized simultaneously using a heat map. One measure is assigned to size, whereas another measure is attached to the color of the heat map.
For example, consider the data source such as the Sample-Superstore and its dimensions and measures.
The procedure to create a heat map is given step by step as follows:
Step 1: First, go to the worksheet.
Step 2: Hold the Ctrl key in the keyboard.
Step 3: Select the dimension Sub-Category and measure Sales as shown in the following screenshot.

tableau 125
tableau

Step 4: Click on the “show me” button of the worksheet.
Step 5: And select the Heatmap icon, as shown in the following screenshot.

tableau 126
tableau

Step 6: Drag measure Profit and drop into the Color shelf under the Marks pane.

tableau 127
tableau

Step 7: Drag the dimension Region and drop into the column shelf.

tableau 128
tableau

After completing all the above steps, it creates the Heatmap, which is used to visualize the Sales field and Profit field across different the dimension.

tableau 129
tableau

So, this brings us to the end of blog. This Tecklearn ‘How to Create Dual Axis Chart , Box Plot and Heat Map 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 Dual Axis Chart, Box Plot and Heat Map in Tableau"

Leave a Message

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