How Tableau Table Calculations Work

Connect with us:
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn:   / eric-parker-37513249  

Description:
Table Calculations are a family of functions in Tableau Desktop which allow users to reference data at the aggregated, data point (mark) level. They are a powerful but often misunderstood component of the Tableau ecosphere.

Some of the most common applications of Table Calculations include calculating Percent of Total, Percent Difference and Rank.

Table Calculations differ from standard calculations in a number of key ways. First, standard calculations typically create a new column of data in the data source. Table Calculations do not. Table Calculations are flexible and their application is specific to the worksheet they are used on and what dimensions are used in that sheet.

When using Table Calculations, you also have the ability as a user to set a Scope (Table, Pane, Cell) and Direction (Across, Down, etc.). Scope and Direction allow you to answer the question, "How do I want this Table Calculation to compute?" For example, if you have two dimensions (State and City) and one measure (Sales) and want to calculate a percent of total, you have two main options.

Option 1: Calculate the percent of total across all cities/states so the entire worksheet adds up to 100%.

Option 2: Calculate the percent of total where each state is the scope so each state adds up to 100%.

The more dimensions in the view, the more options you have available.

Want to master the basics of Table Calculations? Check out this in-depth video to better understand what they are, how they work, and how they can help you!

Resources:
•Tableau Public Workbook: https://public.tableau.com/app/profil...
•Table Calculation Errors: https://onenumber.biz/blog-1/2019/8/1...
•Table Calculations - Specific Dimensions: https://onenumber.biz/blog-1/2018/1/1...
•Highlighting Points in a Line Graph (RANK): https://onenumber.biz/blog-1/2017/10/...

Chapters:
0:00 Table Calcs Background
3:03 WINDOW_AVG Example
5:50 How Filters Affect Table Calcs
8:00 Percent of Total Example (Scope & Direction)
16:11 Percent Difference Example
22:28 Table Calcs and Aggregations