Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

Tableau Box Plot

by suresh

Tableau Box Plot is useful for graphically visualizing the numeric data, group by specific data. Let us see how to Create a Box Plot in Tableau with an example. For this Tableau boxplot demo, we are going to write the Custom SQL Query on the SQL Server Data Source.

How to Create a Tableau Box Plot

Please refer Connecting Tableau to SQL Server to understand the configurations. The custom SQL query that we are going to use for this Tableau report is:

-- SQL Query to create a Box Plot in Tableau
SELECT ProdCat.EnglishProductCategoryName, 
       ProdSubCat.EnglishProductSubcategoryName, 
       Geo.EnglishCountryRegionName, 
       Geo.StateProvinceName, 
       Geo.City, 
       Geo.PostalCode, 
       Geo.IpAddressLocator, 
       Prod.EnglishProductName, 
       Prod.Color, 
       Prod.DealerPrice, 
       Cust.FirstName, 
       Cust.LastName, 
       Cust.Gender, 
       Cust.YearlyIncome, 
       Cust.EnglishEducation, 
       Cust.EnglishOccupation, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.OrderDate
FROM DimProductSubcategory AS ProdSubCat
   INNER JOIN
     DimProduct AS Prod ON ProdSubCat.ProductSubcategoryKey = Prod.ProductSubcategoryKey 
   INNER JOIN
     DimProductCategory  AS ProdCat ON ProdSubCat.ProductCategoryKey = ProdCat.ProductCategoryKey 
   INNER JOIN
     FactInternetSales AS Fact ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN
     DimCustomer AS Cust ON Fact.CustomerKey = Cust.CustomerKey
   INNER JOIN
     DimGeography AS Geo ON Cust.GeographyKey = Geo.GeographyKey

In this example, we are going to create a boxplot in Tableau. For this, first drag and drop the Sales Amount from Measures Region to Rows Shelf, and Color from Dimensions region to Details field present in Marks Shelf.

Tableau intelligence automatically creates the Bar Chart, but we want to create a Box plot so, please select the Box plot option from the Show Me window as shown below

Tableau Box Plot 1

From the below screenshot, you can see the Tableau Boxplot.

Tableau Box Plot 2

Let me drag and drop the English Country Region Name from Dimensions to Columns Shelf. It will create a box plot for each country

Tableau Box Plot 3

You can hover over the mouse on the box plot to see the Median, Upper Quartile, Lower Quartile, and the Whisker values.

Tableau Box Plot 4

Change Colors of a Tableau Box plot

In this example, we show you how to change the colors of a Tableau Boxplot boxes. Tableau provides two different approaches to this.

First Approach: Please right-click on the box plot and select the Edit.. option from the context menu.

Tableau Box Plot 5

Once you select the Edit.. option, a new window called Edit Reference Line, Band, or Box will open to style the box plot.

Tableau Box Plot 6

Second Approach: Go to the Format menu and select the References Lines… will open the Format Reference Lines tab.

Tableau Box Plot 7

Let me change the Fill color to the Red pallet.

Tableau Box Plot 8

Next, we are changing the Border width and border color for Tableau box plot

Tableau Box Plot 9

Lastly, we are changing the Tableau Whiskers width and color

Tableau Box Plot 10

Change Colors of a dots in Tableau Box Plot

This example explains how to add colors to the dots in the Tableau boxplot. For this, drag and drop the English Country Name from Dimensions Region to the Color field in Marks Shelf, as shown below. It means each country has its own color

Tableau Box Plot 11

Change the Size of a dots in Tableau Box Plot

In this example, we will show you how to change the size of the dots in a box plot. For this, drag and drop the Order Quantity from Measures Region to Size field in Marks Shelf, as shown below.

Tableau Box Plot 12

Create Categorical Box Plots in Tableau

Here, we show how to create a boxplot in Tableau for each color within a region. For this, drag and drop the Color from Dimensions Region to Columns Shelf.

By default, the box plot displays the horizontal lines (or dots), and they are the compressed box plot. Because it is difficult to draw the box plots for aggregated data, so, let’s remove the aggregated measure by unchecking the Aggregate Measures available in Analysis Menu, as shown below.

Tableau Box Plot 13

Now you can see the box plot for each color present in a region.

Tableau Box Plot 14

Horizontal Tableau Box plot

In this example, we will show you how to change the default vertical box plot into a horizontal box plot by swapping rows and columns

Tableau Box Plot 15

Below screenshot will show you the horizontal box plot in Tableau

Tableau Box Plot 16

Placed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy