23rd October, 2018
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.
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.
Step 5 - In the Table Calculation dialog box, in the Calculation Type list, select Percent of Total.
Step 6 - In the Compute the total within list, select Pane (Down).
The resulting view will look like this:
For indepth knowledge on Tableau, click on below
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 .
Write For Us