Tableau-Desktop-Found Exploring and Analyzing Data Practice Question
Exhibit
JSON Policy: { 'Aggregation': 'Sum', 'Calculation': 'WINDOW_AVG(SUM([Sales]), -3, 0)', 'Partition': 'Date_Month' }Refer to the exhibit. What is the effect of the calculation on the visualization?
⚠ Common exam trap
Candidates often misread the index offset in the window calculation, incorrectly guessing the time frame. They struggle to identify that 'window_avg' looks at the current row plus previous rows.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
It computes a 4-month rolling average
The calculation creates a 4-month rolling average (current month plus the 3 previous months). By using a window calculation, Tableau looks at the result set currently in the view and performs an average on that subset. This is a common requirement for smoothing out seasonality in sales data, enabling analysts to identify long-term growth trends rather than being distracted by monthly volatility.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
It calculates the average of all months
Why it's wrong here
The calculation does not average the entire dataset; it uses a window of -3 to 0. This restricts the calculation to a rolling look-back period of 4 months. If it averaged all months, the window parameters would be unnecessary or set differently to reflect the entire data scope.
- ✓
It computes a 4-month rolling average
Why this is correct
The WINDOW_AVG function with a range of -3 to 0 includes the current month and the three preceding months, effectively creating a 4-month rolling average. This is a standard analytical technique for smoothing time-series data and highlighting underlying trends that might be obscured by monthly data noise.
- ✗
It calculates the average for the current year
Why it's wrong here
The calculation is based on the partition 'Date_Month', which acts sequentially regardless of the year. There is no logic in the WINDOW_AVG function that resets or filters based on the calendar year, so it would continue across year boundaries rather than restricting itself to a single year.
- ✗
It is a row-level calculation
Why it's wrong here
WINDOW_AVG is a table calculation, not a row-level calculation. It requires the data to be aggregated in the view first, as it operates on the summarized values in the result set. Row-level calculations are computed for every individual row in the data source, which this does not do.
About these practice questions
Courseiva writes every Tableau-Desktop-Found question from scratch — 126 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.