Calculating percentages of a table total

Keyboard Shortcuts

You can analyze data in many ways, but one of the most popular methods is to determine how much at cell in a table contributes to the total value of all cells, or just the cell's column or row. In this movie, I’ll show you how to calculate the percentage that each cell in a table contributes to the grand total.

- [Instructor] You can analyze your data in many ways.…But one of the most useful methods is to…determine how much a cell in a table…contributes to the total value of all sales.…You can also perform this analyses…for individual rows or columns.…In this movie, I will show you how…to calculate the percentage that each cell in a table,…or row or column, contributes to the whole.…My sample file is the table percent workbook…and you can find it in the chapter five…folder of your exercise files collection.…

I have a text table that contains…the total expenditures for properties by state.…The two states with the lowest expenditures…are California and Virginia and that's because…there are two properties in those states.…What I would like to do is to display…rather than the raw totals, the amount that…each of these totals contributes to the whole.…To do that I can open the analysis menu…and point to percentage of and there I can select…the element of the table that I want to summarize…or at least base the percentages on.…

Resume Transcript Auto-Scroll

Author

Updated

5/10/2017

Released

10/13/2016

Tableau is the widely used data analytics and visualization tool that many consider indispensable for data-science-related work. Its drag-and-drop interface makes it easy to sort, compare, and analyze data from multiple sources, including Excel, SQL Server, and cloud-based data repositories. Tableau 10: Essential Training explains everything you need to know to analyze and display data using Tableau Desktop—and make better, more data-driven decisions for your company. After completing the course, you'll be able to install Tableau, connect to data sources, summarize data, and create, manipulate, and share data visualizations, including highlight tables, charts, scatter plots, histograms, maps, dashboards, and more.

Topics include:

Managing data sources and visualizations

Managing Tableau worksheets and workbooks

Creating custom calculations and fields

Analyzing data using statistical tools

Sorting and filtering Tableau data

Defining groups and sets

Creating and pivoting crosstabs

Formatting Tableau visualizations

Creating basic charts

Annotating and formatting charts

Mapping geographic data

Creating dashboard and actions

Skill Level Intermediate

4h 41m

Duration

1,537,175

Views

Show MoreShow Less

Q. This course was updated 5/10/2017. What topics were part of the update?

A. Topics related to version 10.1 and 10.2 were part of the course update.