Data Bin's in Tableau

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

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.

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

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses

1/15

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.