Study guide
6.2 Essential Table Calculations: Running, Window & Percent of Total
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.2 Essential Table Calculations: Running, Window & Percent of Total
Key Takeaways Explain This Topic AI
Table calculations operate on aggregated marks and depend on view structure, sort order, addressing, and partitioning.
A three-period trailing frame including the current mark uses offsets -2 through 0.
TOTAL returns the total of its expression over the configured partition; it is not a universal source re-query for non-additive measures.
Difference and percent-difference calculations need a valid comparison mark and a protected denominator.
Quick table calculations are starting configurations that can be customized with directions or Specific Dimensions.
Last updated: September 2026
6.2 Essential Table Calculations: Running, Window & Percent of Total
Table calculations operate on the aggregated marks returned for a view. They do not add detail rows to the source query. Their meaning therefore depends on the view's dimensions, sort order, addressing direction, and partition boundaries. Before selecting a function, state which marks the calculation should traverse and where it should restart.
Running calculations
A running total accumulates from the first addressed mark through the current mark. The explicit form is RUNNING_SUM(SUM([Sales])). If Month is addressed left to right and Region partitions the view, each region receives its own cumulative monthly series. RUNNING_AVG, RUNNING_MIN, RUNNING_MAX, and RUNNING_COUNT use the same addressing concept.
Running totals require a meaningful order. A date axis sorted chronologically is appropriate; an arbitrary alphabetical product order usually is not. Missing periods also matter. If February has no mark, Tableau does not invent a February value unless the date domain is completed or densified by the view.
Window calculations
WINDOW_SUM, WINDOW_AVG, WINDOW_MIN, WINDOW_MAX, WINDOW_MEDIAN, and related functions evaluate a frame within the partition. The optional start and end offsets are relative to the current mark, which is zero. Negative offsets look backward and positive offsets look forward.
For a three-month trailing average including the current month, use: WINDOW_AVG(SUM([Sales]), -2, 0)
The frame contains offsets -2, -1, and 0. At the beginning of the partition, fewer than three marks may be available, so decide whether a partial window is acceptable. WINDOW_SUM(SUM([Sales]), FIRST(), LAST()) spans the partition; a fixed frame can be narrower.
Difference and percent difference
Difference From compares the current aggregate with another mark, commonly the previous one. An explicit difference is SUM([Sales]) - LOOKUP(SUM([Sales]), -1). Percent Difference From divides that difference by an appropriate prior value. Protect the denominator against zero and decide whether ABS is consistent with the business definition.
LOOKUP returns null when its offset falls outside the partition. The first month of a previous-month comparison therefore has no prior result. That is expected, not a calculation failure. If a normal dimension filter removes the prior month before table calculations run, LOOKUP also returns null; a late table-calculation filter can hide marks without removing the history needed for the comparison.
- Percent of total and TOTAL
- A common percent-of-total formula is: SUM([Sales]) / TOTAL(SUM([Sales]))
TOTAL returns the total of the supplied expression across its configured table-calculation partition. With Category addressed within Region, each category can be divided by its regional partition total. If Compute Using instead spans the full table, the denominator changes. Confirm that the expected marks sum to 100%.
TOTAL and WINDOW_SUM may produce the same result for additive SUM values over the same full partition. Neither should be assumed to repair an invalid aggregation merely because its name contains Total. Non-additive measures such as COUNTD, MEDIAN, and ratios require a calculation designed at the correct data grain. A displayed grand total can also use Tableau's total aggregation behavior and should be tested separately.
Rank, percentile, and index
RANK, RANK_DENSE, RANK_MODIFIED, RANK_PERCENTILE, and RANK_UNIQUE handle ties differently. RANK_DENSE produces 1, 2, 2, 3; ordinary RANK produces 1, 2, 2, 4. Set ascending or descending order explicitly and compute along the entity being ranked within the intended partition.
INDEX returns the position of the current mark in the partition, starting at one. It is useful for display logic and some ranking layouts but changes when sorting or partitioning changes. SIZE returns the number of marks in the partition. FIRST and LAST return offsets from the current mark to the first and last marks.
Percentile can mean a rank percentile table calculation or a source-level percentile function depending on the field and connector. A table calculation ranks the marks present in the partition. State which population and tie behavior the question requires.
Quick table calculations and customization
The pill menu offers quick calculations such as Running Total, Difference, Percent Difference, Percent of Total, Rank, Percentile, and Moving Calculation. This adds a configured table calculation to the measure. Use Edit Table Calculation to choose relative directions such as Table Across or Pane Down, or use Specific Dimensions for a field-based configuration that is more resilient to rearranging shelves.
When a quick calculation does not exactly match the requirement, edit it or create an explicit calculated field. A moving calculation exposes the aggregation, number of values, direction, and treatment of nulls. A secondary calculation can apply another transformation to the first result, and nested calculated fields can have separate Compute Using configurations through the nested-calculation selector.
Reliable workflow
Build and validate the base aggregate without a table calculation.
Identify the marks to address and the dimensions that define partitions.
Choose the calculation and required order.
Configure Compute Using, preferably with Specific Dimensions for complex views.
Test the first, middle, and last marks and each partition reset.
Add or remove dimensions and verify that the result still means what its label claims.
Use a late display filter only when earlier marks must remain available to the calculation.
A correct formula with the wrong addressing direction is still a wrong answer. The partition is the population; addressing is the path through that population.