Study guide
6.1 Table Calculation Mechanics: Addressing vs. Partitioning
Salesforce Certified Tableau Data Analyst Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Connecting to Data & The Logical Data Model
1.1 Data Connections: Live Connections vs. Hyper Extracts 1.2 The Tableau Data Model: Relationships vs. Physical Joins 1.3 Combining Data: Data Blending vs. Cross-Database Joins
2 Chapter 2: Tableau Prep Builder & Data Wrangling
2.1 Tableau Prep Architecture & Data Cleaning 2.2 Reshaping Data in Prep: Pivots, Splits & Wildcard Unions 2.3 Joins, Aggregations & Output Destinations in Prep
3 Chapter 3: Data Quality, Metadata & Field Configuration
3.1 Data Types, Roles, Organization & Default Properties 3.2 In-Desktop Data Cleaning: Splits, Data Interpreter & Source Replacement 3.3 Managing Slowly Changing Dimensions & Data Quality Warnings
4 Chapter 4: Tableau Fundamentals & Calculations
4.1 Dimensions vs. Measures & Discrete vs. Continuous 4.2 Mastering Dates: Discrete Date Parts vs. Continuous Date Truncations 4.3 Calculations: Logic, Strings, Nulls & Type Conversion 4.4 Aggregation Rules, Granularity & Dealing with the Asterisk (ATTR)
5 Chapter 5: Level of Detail (LOD) Expressions
5.1 Level of Detail Architecture & Scoping Syntax 5.2 FIXED LOD Expressions: Scoping & Baseline Benchmarks 5.3 INCLUDE & EXCLUDE LOD Expressions: Dynamic Granularity 5.4 Real-World LOD Patterns: Cohorts, First/Last Dates & Binning
6 Chapter 6: Table Calculations & Directionality
6.1 Table Calculation Mechanics: Addressing vs. Partitioning 6.2 Essential Table Calculations: Running, Window & Percent of Total 6.3 Navigation & Ranking Functions: LOOKUP, INDEX & RANK 6.4 Secondary & Nested Table Calculations: Multi-Level Scoping
7 Chapter 7: Statistical Analytics, Filtering & Order of Operations
7.1 The Tableau Order of Operations: From Extract to Display Filters 7.2 Sets, Set Actions & Combined Sets vs. Groups 7.3 Parameters, Parameter Actions & Dynamic What-If Analysis 7.4 Analytics Pane: Totals, References, Trends & Forecasts
8 Chapter 8: Chart Types & Comparative Visualizations
8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs 8.2 Part-to-Whole & Correlation Charts: Treemaps, Scatter Plots & Bubbles 8.3 Trend & Distribution Visualizations: Dual-Axis, Combos & Histograms
9 Chapter 9: Advanced Visualizations & Spatial Analysis
9.1 Specialized Visualizations: Waterfall, Gantt, Sparklines & Bump Charts 9.2 Spatial Data & Mapping: Geographic Layers & Spatial Functions 9.3 Visual Polish: Custom Palettes, Annotations & Viz in Tooltip
10 Chapter 10: Dashboard Design & Interactive Actions
10.1 Dashboard Layout, Devices & Visibility 10.2 Filter, Highlight & URL Actions 10.3 Advanced Interactivity: Parameter, Set & Navigation Actions 10.4 Stories & Visual Storytelling: Sequencing Analytical Narratives
11 Chapter 11: Tableau Server & Cloud: Architecture & Publishing
11.1 Tableau Server & Cloud: Sites, Projects, Roles & Permissions 11.2 Publishing Workbooks, Data Sources & Flows
12 Chapter 12: Data Governance, Security & Operations
12.1 Certification, Data Quality, Lineage & Permissions 12.2 Row-Level Security, Schedules, Subscriptions & Alerts
6.1 Table Calculation Mechanics: Addressing vs. Partitioning
Key Takeaways Explain This Topic AI
Table calculations execute strictly on the local aggregated cache returned by the underlying database query, operating on visual marks rather than row-level database records.
Addressing dimensions (Compute Using) define the direction and sequence along which the calculation traverses, with values accumulating or comparing across addressing marks.
Partitioning dimensions establish boundary scopes that group data, causing the table calculation to reset and restart independently for each distinct partition value.
Relative directional options (Table across, Table down, Pane down) are view-dependent and dynamically reconfigure if shelf dimensions are rearranged or rotated.
Specific Dimensions configuration explicitly declares addressing fields, nesting order, and 'Restarting every' thresholds, ensuring every shelf dimension acts as either addressing or partitioning.
Last updated: September 2026
6.1 Table Calculation Mechanics: Addressing vs. Partitioning
In the Tableau calculation hierarchy, Table Calculations occupy a unique and vital position. Unlike row-level calculations (which evaluate record by record in the source data) or aggregate calculations (which evaluate across groups of records determined by the visualization's level of detail), table calculations evaluate after the database has aggregated and returned the query results. Understanding where, when, and how table calculations compute is one of the important competencies on the Salesforce Certified Tableau Data Analyst examination.
The Table Calculation Pipeline: Local Cache Processing
The fundamental architectural principle of table calculations is that they never execute within the underlying database . When an analyst drags dimensions and measures onto a worksheet, Tableau generates an aggregate query (SQL, MDX, or Hyper query) and transmits it to the data engine. The database computes the aggregations and returns a summarized tabular result set to Tableau's local client cache. [Underlying Database]
- |
- | 1. SQL Aggregate Query (SUM, AVG, COUNT)
- v
- [Tableau Local Cache / Visual Data Table]
- |
- | 2. Table Calculations Applied (RUNNING_SUM, WINDOW_AVG, RANK)
- v
- [Rendered Canvas / Visual Marks]
The table calculation engine operates exclusively upon this local aggregate table. Because the computation happens in memory on the summarized result set, table calculations offer two distinct operational characteristics:
High Computation Speed: Because the computation runs on hundreds or thousands of summarized rows rather than millions of transactional rows, operations like running totals and rankings execute almost instantaneously.
View-Dependency: If a dimension is removed from the view, filtered out, or rearranged on the shelves, the structure of the underlying visual table changes, directly altering the output of the table calculation.
Core Mechanics: Addressing vs. Partitioning
Every table calculation requires two fundamental instructions: what to group by and what direction to move along . In Tableau terminology, these concepts are formalized as Partitioning and Addressing .
Addressing Dimensions (Compute Using)
Definition: The dimension or dimensions along which the calculation proceeds. Addressing defines the path, vector, and ordering of evaluation.
Behavior: Values change along the addressing dimensions. The calculation steps from one member of the addressing dimension to the next, accumulating, comparing, or ranking values.
User Interface Term: In the Tableau interface, addressing dimensions are configured under the Compute Using menu or selected as checked boxes in the Specific Dimensions list.
Partitioning Dimensions (Scope Boundaries)
Definition: The dimension or dimensions that group the data into isolated, independent subsets (partitions).
Behavior: The calculation restarts for each partition. Calculations in one partition are completely unaware of and unaffected by data in adjacent partitions.
User Interface Term: In the Tableau interface, partitioning dimensions are represented by unchecked boxes in the Specific Dimensions list.
Important
The Universal Partitioning Rule: Every single dimension present in the active worksheet (on Rows, Columns, Pages, or Marks card shelves such as Color, Size, Label, Detail, and Shape) must participate in the table calculation. Each dimension is assigned to either Addressing or Partitioning. A dimension cannot be neutral or omitted.
Comparison: Addressing vs. Partitioning
Feature Addressing Dimensions Partitioning Dimensions
Interface Representation Checked boxes in Specific Dimensions; selected under 'Compute Using' Unchecked boxes in Specific Dimensions
Computational Action Defines the path, direction, and order of movement Defines the boundaries where the calculation resets
Calculation Reset Never resets within the addressing sequence (unless 'Restarting every' is configured) Resets to the initial value upon entering every new partition
Value Progression Values accumulate, offset, or compare across these dimension members Each partition computes in complete isolation
Analogy The steps taken along a running track The individual laps or distinct runners
Example (Regional Monthly Sales) If Order Date (Month) is addressing, RUNNING_SUM accumulates Jan -> Feb -> Mar If Region is partitioning, the running sum starts fresh at $0 for Central, East, South, West
Relative Directions: Moving Across the Visual Grid
Tableau provides built-in relative directional settings. These directions interpret the visual grid formed by the dimensions placed on the Rows and Columns shelves: +-----------------------------------------------------------------------------------+
- | TABLE (ACROSS): Moves horizontally across columns; resets at each row |
- | TABLE (DOWN): Moves vertically down rows; resets at each column |
- | TABLE (ACROSS THEN DOWN): Moves across row, then wraps down without resetting |
- | TABLE (DOWN THEN ACROSS): Moves down column, then wraps across without resetting |
- | PANE (DOWN): Moves down within a pane; resets at each outer row/column header |
- | PANE (ACROSS): Moves across within a pane; resets at each outer header |
- | CELL: Confined strictly to the single cell mark (e.g. 100% of cell) |
- +-----------------------------------------------------------------------------------+
- Detailed Relative Directional Behaviors
Table (across): Computes horizontally across the entire width of the table. The calculation restarts after the last column for each row. The addressing dimension is the innermost dimension on Columns; dimensions on Rows act as partitions.
Table (down): Computes vertically down the entire length of the table. The calculation restarts after the last row for each column. The addressing dimension is the innermost dimension on Rows; dimensions on Columns act as partitions.
Table (across then down): Computes horizontally across the first row, then wraps down to the start of the second row, continuing the calculation without resetting until the very end of the table.
Table (down then across): Computes vertically down the first column, then wraps to the top of the second column, continuing the calculation across the entire table without resetting.
Pane (down): Operates within an individual pane (defined by outer hierarchical dimensions). It computes down the rows of that specific pane and resets when transitioning to the next pane.
Pane (across): Operates within an individual pane horizontally and resets at the boundary of each pane.
Cell: Evaluates strictly within the borders of an individual intersection mark. For example, a Percent of Total calculated using Cell produces 100% for every mark, because each mark represents the entirety of its own partition.
The Vulnerability of Relative Directions
While relative directions are convenient, they are visually fragile . If an author builds a worksheet using Table (down) and an end-user swaps Rows and Columns (or pivots the visual layout), the calculation continues to move down vertically, which now traverses a completely different dimension! For robust enterprise reporting, explicit dimension addressing is strongly preferred.
Explicit Configuration: Specific Dimensions
To prevent calculation breakage when views are rearranged, Tableau allows authors to explicitly define Addressing and Partitioning using Specific Dimensions in the Table Calculation configuration dialog.
How Specific Dimensions Operates
Checked Dimensions: Assigned to Addressing . The calculation moves along these fields.
Unchecked Dimensions: Assigned to Partitioning . The calculation groups by and resets at every unique combination of these fields.
Hierarchy and Drag Order: In the Specific Dimensions box, checked dimensions can be dragged up or down. The order from top to bottom dictates the nesting hierarchy of addressing. Tableau evaluates addressing along the outermost checked dimension first, followed by the inner checked dimensions. Table Calculation Configuration Dialog:
- +-------------------------------------------------------------+
- | Compute Using: |
- | ( ) Table (across) |
- | ( ) Table (down) |
- | (*) Specific Dimensions |
- | [X] Region <-- Addressing (Outer) |
- | [X] Category <-- Addressing (Inner) |
- | [ ] Segment <-- Partitioning (Reset here) |
- | |
- | Restarting every: [ Region |v] |
- | Sort order: [ Specific Sort: SUM(Sales) |v] |
- +-------------------------------------------------------------+
- The 'Restarting Every' Setting
When multiple dimensions are checked for Addressing, the Restarting every dropdown becomes active. This allows authors to maintain an addressing dimension while enforcing a calculation reset at a higher level within the addressing list. For example, an analyst can include both Year and Month in addressing to calculate a rolling metric, but set Restarting every to Year so that the calculation clears and starts over on January 1st of each year.
Custom Sort Order within Table Calculations
By default, addressing dimensions traverse values according to the visual sort order of the worksheet. However, within the Table Calculation dialog under Sort order , authors can specify a Custom Sort (e.g., sorting by SUM([Sales]) Descending ) that overrides the visual sort on the canvas without altering the visual arrangement of headers.
Quick Table Calculations vs. Custom Table Calculations
Tableau provides two workflows for implementing table calculations:
1. Quick Table Calculations
Accessed by right-clicking any aggregated measure pill on a shelf and navigating to Quick Table Calculation .
Offers pre-configured common formulas: Running Total, Difference, Percent Difference, Percent of Total, Rank, Percentile, Moving Average, YTD Total, Compound Growth Rate, Year Over Year Growth, YTD Growth .
When applied, Tableau automatically converts the green pill into a table calculation, indicated by a small triangle icon (delta symbol: Δ) on the right side of the pill.
2. Custom Table Calculations
Created by authoring a calculated field in the Calculation Editor using Tableau's native table calculation syntax (e.g., RUNNING_SUM(SUM([Sales])) , WINDOW_AVG(SUM([Profit]), -3, 0) ).
Can be saved as permanent fields in the Data pane, assigned descriptive business names, reused across multiple worksheets, and incorporated into complex multi-layered formulas.
Can also be created by dragging an existing Quick Table Calculation pill from a shelf directly into the Data pane, which converts the ad-hoc calculation into a reusable calculated field.
- Exam Traps & Practical Scenarios
- Scenario 1: Unintended Partitioning from the Detail Shelf
An analyst configures a RUNNING_SUM(SUM([Sales])) across Order Date (Month) with Table (across) . The calculation displays a smooth cumulative line. The analyst then drags Customer Segment onto the Detail shelf on the Marks card to encode customer types. Suddenly, the single smooth cumulative line breaks into three jagged, lower-value lines.
The Cause: When Customer Segment was added to the Marks card, it entered the visual level of detail. Because Table (across) was set, the newly added dimension defaulted to a partitioning dimension . The running total now resets and computes independently for each segment.
The Remedy: Open the Table Calculation editor, switch to Specific Dimensions , and ensure Customer Segment is checked if accumulation should span across all segments, or retain it as partitioning if separate segment lines were intended.
Scenario 2: Relative Directions in Swapped Charts
An executive requests that a vertical bar chart showing Percent of Total sales down sub-categories ( Table (down) ) be pivoted into a horizontal bar chart. The analyst clicks the 'Swap Rows and Columns' button. The chart bars now display horizontally, but every single bar shows 100% !
The Cause: Under Table (down) , the calculation computed along Rows. When the shelves were swapped, the sub-categories moved to Columns, and Rows became empty. Computing Table (down) on a view with only one row treats each column mark as an entire partition, yielding 100% per bar.
The Remedy: Update the Compute Using setting to Table (across) , or lock the calculation permanently to Specific Dimensions: Sub-Category .