Tableau Bins are useful to create a Range of data, which is similar to SQL Buckets. In this article, we will show you How to Create Bins in Tableau with an example.
To create bins in tableau, we are going to write the Custom Query against the SQL Server Data Source. Please visit Connecting to SQL Server article to understand the configurations. 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 Dimension Region to Rows Shelf. Next, Drag and Drop the Sales Amount from Measures Region to Filed region. Since it is a Measure value, the Sales Amount will aggregate to default Sum.
Once you drag them, the table report will generate. You can observe that there are 158 row.
Create Bins in Tableau
In this Tableau bins example, we are going to create Buckets on Product Key. As we know, numeric bucket is a group of equal sized data. So, Please right-click on the Product Key dimension and select Create option and choose the below shown option from the context menu.
Once you select the option, a new window called Create dialog box will open with default Name and default size 10.
If you don’t know the size, click on the Load button. By clicking this button, the desktop will display the Minimum, Maximum, Difference values and also the best possible size.
For now, We are using the Static Number 20 as Size of it and Click Ok to merge data into groups.
It shows the newly created Bin in Tableau Dimension section
Please replace Product Key dimension with Product Key Bucket on Row Shelf.
From the above Tableau Bins screenshot, you can observe that Product Key Data organized into Buckets and the total rows are 21 only. To display the product keys available in each group, Drag and Drop the Product key dimension to the Row Shelf
From the above screenshot, you can see the newly created one in table report.
How to Delete Tableau Bins
It is effortless and straightforward to delete the Bins in Tableau. 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.
Create a Stacked Bar Chart using Tableau Bins
Tableau allows us to create Bins on both Dimensions and Measures and in this example, we will generate on Measure value. Using that value, we create a Stacked Bar Chart. The following screenshot will show you, Default Bar Chart with Color dimension on Row Shelf and Sales Amount on Column Shelf
Right Click on the Sales Amount Measure and select Create option from the menu. Now, we are using the default size generated by the Desktop (i.e., 357.598)
Next, Drag and Drop the newly created Sales Amount bucket from Dimension region to the Color Option in Marks Card.
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.
Let us add the Data Labels and see, whether we successfully created the stacked bar charts using the Tableau Bins or not.