Tableau Bins

Tableau Bins are useful for creating a range of data, similar to SQL Buckets. This Tableau article will show you How to Create Bins with an example.

To create bins in Tableau, we will write the Custom Query against the SQL Server Data Source. Please visit the Connecting to SQL Server article to understand the configurations. The Custom SQL query we are going to use for this Tableau report is:

SELECT Prod.Productkey, 
       Prod.EnglishProductName, 
       Prod.Color, 
       Prod.DealerPrice, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount
FROM DimProduct AS Prod 
     INNER JOIN FactInternetSales AS Fact 
       ON Prod.ProductKey = Fact.ProductKey

Tableau Bins Example

Before we start creating bins in Tableau, we need a report. First, Drag and Drop the Product Key from the Dimension Region to the Rows Shelf. Next, Drag and Drop the Sales Amount from the Measures Region to the Field region. Since it is a Measure value, the Sales Amount will aggregate to the default Sum.

Once you drag them, the table report will be generated. You can observe that there are 158 rows.

Tableau Bins 2

Create Bins in Tableau

In this Tableau bins example, we are going to create Buckets on the Product Key. As we know, the numeric bucket is a group of equal sized data. So, Please right-click on the Product Key dimension, select the Create option, and choose the below-shown option from the context menu.

Tableau Bins 3

Once you select the option, a new Tableau window called the Create Bins dialog box will open with the default Name and the default size of 10.

Tableau Bins 4

If you don’t know the Tableau Bin size, click on the Load button. The desktop will display the Minimum, Maximum, and Difference values and the best possible size by clicking this button.

Tableau Bins 5

For now, We are using the Static Number 20 as the Size and Clicking OK to merge data into groups.

Tableau Bins 6

It shows the newly created Bin in the Dimension section.

Tableau Bins 7

Please replace the Product Key dimension with the Product Key Bucket on the Row Shelf.

Tableau Bins 8

From the above Tableau Bins screenshot, you can observe that Product Key Data is organized into Buckets, and the total rows are only 21. Drag and Drop the Product key dimension to the Row Shelf to display the product keys available in each group.

Tableau Bins 9

From the above screenshot, you can see the newly created one in the table report.

How to Delete Tableau Bins

It is effortless and straightforward to delete the Bins. To do so, Select the one you want to delete and right-click on it will open the context menu. From that, Please select the Delete Option.

Delete Tableau Bins

Create a Stacked Bar Chart using Bins

This Tableau desktop tool allows us to create Bins on both Dimensions and Measures, and in this example, we will generate a Measure value. Using that value, we create a Stacked Bar Chart. The following screenshot will show you the Default Bar Chart with Color dimensions on the Row Shelf and the Sales Amount on the Column Shelf.

Bar Chart

Right Click on the Sales Amount Measure and select the Create option from the menu. Now, we are using the default bin size generated by the Tableau Desktop (i.e., 357.598)

Changing the Size

Next, Drag and Drop the newly created Sales Amount bucket from the Dimension region to the Color Option in Marks Card.

Add Measure to Color Shelf

Once you complete it, You can see the Stacked Bar Chart. The Desktop allocates default colors to stacked bars, but You can edit the colors by selecting the Edit Colors.. option.

Stacked Bar Chart

Let us add the Data Labels and see whether we successfully created the stacked bar charts using the Tableau Bins or not.

Tableau Stacked Bar Chart using Bins

Comments are closed.