• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Data Bin’s in Tableau

Sometimes it’s useful to organize the values of a measure into bins. For example, suppose you have a measure that holds the ages of customers ranging from 18 to 90. If you wanted to analyze how customer value breaks down by different age groups, you would bin the data. Also, to create a histogram you must first bin data.

In Tableau, bin data by highlighting a numeric dimension or measure in the Data window and selecting Create Bins from the context menu.

Example:

Let’s calculate the percentage of total sales for each item in a product category. The view will use the Percent of Total table calculation and apply it to the pane. The calculation is dynamic which means that as I change the dimensions in the view the calculation will always compare the values within the current pane.

Our course design of tutorials is practical and informative. At TekSlate, we offer resources to
 help you learn various IT courses. We avail both written material and demo video tutorials. 
For in-depth knowledge and practical experience explore Tableau Training Material.

Step 1 – Open a new workbook and connect to the Superstore sample.

Step 2 – From the Dimensions pane, drag Product Category and Product Sub-Category to the Rows shelf.

Step 3 – From the Measures pane, drag Sales to the Text shelf on the Marks card.

Step 4 – On the Text shelf, right-click Sales and select Add Table Calculation.

Tableau_DataBin

Step 5 – In the Table Calculation dialog box, in the Calculation Type list, select Percent of Total.

Tableau_DataBin1

Step 6 – In the Compute the total within list, select Pane (Down).

The resulting view will look like this:

Tableau_DataBin2

For indepth knowledge on Tableau, click on below

Summary
Review Date
Reviewed Item
Data Bin's in Tableau
Author Rating
4

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Data Bin's in Tableau"

Leave a Message

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

Site Disclaimer, Copyright © 2016 - All Rights Reserved.