How to Calculate a Percent of Total for Measure Values in Tableau
218.8 هزار بار بازدید -
6 سال پیش
-
In this video, you'll see
In this video, you'll see how to calcualte a percent of total for measure values in Tableau.
Calculating Percent of Total for Measure Values: http://kb.tableau.com/articles/howto/...
Use the following steps to calculate the percent of total for the Sales Furniture, Sales Office Supplies, and Sales Technology measure fields:
1.Select Analysis - Create Calculated Field.
2.Name the calculation. In the example workbook, the calculation is named "Sales % Furniture".
3.In the formula field, create a calculated field similar to the following and click OK:
SUM( [Sales Furniture] ) / SUM( [Sales] )
4.Repeat steps 1-3 for each new percentage.
5.Create a new worksheet to display the percentage measures. In the example workbook, this worksheet is named "%Measures".
6.Make a new dashboard (Dashboard - New) and drag the Measures and %Measures worksheets onto the view side by side.
Subscribe to the Tableau YouTube channel here: http://www.youtube.com/subscription_c...
Free Trial of Tableau: https://www.tableau.com/products/trial
Calculating Percent of Total for Measure Values: http://kb.tableau.com/articles/howto/...
Use the following steps to calculate the percent of total for the Sales Furniture, Sales Office Supplies, and Sales Technology measure fields:
1.Select Analysis - Create Calculated Field.
2.Name the calculation. In the example workbook, the calculation is named "Sales % Furniture".
3.In the formula field, create a calculated field similar to the following and click OK:
SUM( [Sales Furniture] ) / SUM( [Sales] )
4.Repeat steps 1-3 for each new percentage.
5.Create a new worksheet to display the percentage measures. In the example workbook, this worksheet is named "%Measures".
6.Make a new dashboard (Dashboard - New) and drag the Measures and %Measures worksheets onto the view side by side.
Subscribe to the Tableau YouTube channel here: http://www.youtube.com/subscription_c...
Free Trial of Tableau: https://www.tableau.com/products/trial
6 سال پیش
در تاریخ 1397/05/31 منتشر شده
است.
218,883
بـار بازدید شده