Explore and Analyze Data41% of the exam
Running totals, differences and moving window calculations
Apply quick table calculations to measures, then customize running totals (with secondary calculations), Difference and Percent Difference From (Relative to Previous, Next, First, Last), percent of total, moving calculations and WINDOW_ functions, and keep results intact by hiding rather than filtering.
Create table calculations: Moving average and window average; Percent of total; Running total; Difference and percent of difference; Percentile; Index; Ranking; Apply quick table calculations; Customize table calculations.
~7 min read · 10 practice questions ·
What the exam expects
- Apply a quick table calculation to a measure and know what the menu offers.
- Choose running total, moving calculation, percent of total or a difference type for a requirement, and set Relative to.
- Write RUNNING_SUM and WINDOW_ functions with the right offsets and Compute Using.
- Customize a running total with a secondary calculation, and hide rather than filter to keep results intact.
- Rank, index, percentile and addressing in depth are in Rank, index, percentile and table calculation addressing.
Key terms:
- Table calculation: a transformation computed on the values currently in the view.
- Partition: the group of marks a calculation runs within and restarts for.
- Window: the rows, as offsets from the current row, a WINDOW_ function uses.
- Secondary calculation: a second table calculation on top of a running total or moving calculation.
Key facts
Quick table calculations
- Detail
- Only on measures in the view
Quick menu includes
- Detail
- Moving average, YTD total, Compound growth rate, Year over year growth, YTD growth and six others
Relative to default
- Detail
- Previous; options Previous, Next, First, Last
Running Total aggregations
- Detail
- Sum, Average, Minimum, Maximum
Secondary calculation
- Detail
- Available on Running Total and Moving Calculation
WINDOW_ with no offsets
- Detail
- Uses the entire partition
Filtered-out data
- Detail
- Not considered by table calculations; hide instead
FIXED vs dimension filter
- Detail
- FIXED is computed before dimension filters
- How does Percent From differ from Percent Difference From?
- Why is the first column of a Difference From view blank by default?
- Why doesn't WINDOW_SUM with no start and end give a cumulative value?
- Which aggregations can a Running Total use?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Tableau Data Analyst pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 30 lessons of the Tableau Data Analyst guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Practice exams purchase adds inline bank questions and topic practice (10 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Choose guide-only, practice-only, or save $4 with both