7.4 Analytics Pane: Totals, References, Trends & Forecasts

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

7.4 Analytics Pane: Totals, References, Trends & Forecasts

Key Takeaways Explain This Topic AI

Totals for non-additive measures may be recomputed and should not be assumed to equal the sum of visible cells.

Reference lines and bands use Table, Pane, or Cell scope and do not filter records.

IQR box-plot outliers are candidates for investigation, not automatic data errors.

R-squared and p-values require assumptions and context and do not establish causation.

Forecasts need supported shelves and sufficient ordered history for trend and seasonality.

Last updated: September 2026

7.4 Analytics Pane: Totals, References, Trends & Forecasts

The Analytics pane adds summaries and statistical models to a view. Every result depends on scope, grain, and retained marks. Treat these features as analytical evidence, not automatic proof of causation.

Totals and subtotals

Use Analysis > Totals or the Analytics pane to add row grand totals, column grand totals, and subtotals. Subtotals summarize intermediate levels when nested dimensions are present. Grand totals summarize the edge of the table.

The value shown at a total is not necessarily the arithmetic sum of visible cells. SUM is additive, but AVG, COUNTD, MEDIAN, and ratios may be recomputed at the total level. If category COUNTD values share customers, adding the displayed counts double-counts people. Choose the total aggregation behavior where Tableau offers it and verify a non-additive result independently.

Reference lines, bands, and distributions

A reference line marks a value such as an average, median, constant, parameter, or calculated measure. Its scope may be Table, Pane, or Cell. A table-scoped average uses all relevant marks in the table; a pane-scoped line is recomputed for each pane; a cell-scoped line applies to its cell.

A reference band shades the area between two values. A distribution band can show percentages, percentiles, quantiles, or standard-deviation regions depending on configuration. An average line is a reference-line shortcut for displaying the mean at the selected scope. These objects add context but do not filter records. Use a parameter-backed reference line when viewers should change a target interactively.

Box plots

A box plot summarizes a distribution with quartiles and a median. The box spans the first to third quartiles, and its interior line marks the median. Under the Data within 1.5 times the IQR option, the whiskers extend to the furthest observations within Q1 - 1.5 × IQR and Q3 + 1.5 × IQR. Observations beyond the whiskers appear as individual marks.

Those marks are outliers under this display rule; they are not automatically errors or statistically significant anomalies. Investigate source quality and business context before excluding them. Tableau can instead extend whiskers to the minimum and maximum when that option is selected.

Trend lines

Trend lines model relationships in views with supported continuous fields. Tableau offers model forms such as linear, logarithmic, exponential, power, and polynomial when the data satisfies their requirements. Show the model description to inspect coefficients, residual information, R-squared, and significance results.

R-squared describes how much observed variation the fitted model accounts for in the sample; it does not prove causation or guarantee useful predictions. A p-value is evaluated against a threshold chosen for the analysis. A conventional 0.05 threshold is common, but the threshold should be set before inspecting results and interpreted with sample size, assumptions, multiple testing, residuals, and business consequences. A p-value is not the probability that the relationship occurred by chance.

Trend models can be partitioned by color or other dimensions, producing separate models. Confirm whether the question requires one model across the table or models per category. Excluding marks changes the fitted population.

Forecasting

Tableau's built-in forecast uses exponential-smoothing models. A view needs a supported date field or an ordered dimension and at least one measure. A model needs sufficient observations: at least five data points for estimating a trend, and seasonality generally needs at least two seasons or one season plus five observations. More data may be needed for a stable business forecast.

Forecasting can be unavailable when the view contains unsupported constructs such as table calculations, percent-of-total measures, disaggregated measures, or certain date configurations. Diagnose the shelves before blaming live versus extract mode.

Automatic model selection compares supported trend and season combinations. Additive seasonality models a seasonal effect with roughly constant absolute magnitude; multiplicative seasonality models an effect that scales with the series level. Customize forecast length, prediction interval, seasonality, trend, and ignored recent periods when the data and use case justify it. By default Tableau can ignore the latest partial period; verify whether that period is actually incomplete.

A prediction interval expresses model uncertainty under its assumptions. It is not a guarantee that a future value will fall inside the band. Review residuals, structural breaks, missing periods, and whether the forecast horizon exceeds what the history can support.

Explain Data

Explain Data can examine a selected mark and surface supported statistical explanations, including candidate fields not currently displayed. Tableau excludes unsupported or unsuitable fields and authors can control which fields are eligible. The results identify associations or unusual contributing records for investigation; they do not establish a root cause.

Use Explain Data as a starting point. Check data quality, grain, filters, and alternative hypotheses. A candidate explanation can be affected by correlated fields, small groups, or selection choices.

Choosing the right object

Need Feature
Show a final row or column summary Grand total
Summarize intermediate dimension levels Subtotal
Compare marks with a benchmark Reference line
Highlight a target interval Reference band
Show quartiles and IQR-defined outliers Box plot
Model an association between continuous fields Trend line
Project an ordered series Forecast
Generate candidate explanations for a selected mark Explain Data
Verification checklist

Confirm the grain and retained population.

Set Table, Pane, or Cell scope deliberately.

Reconcile totals, especially for non-additive measures.

Inspect model assumptions and residuals rather than relying on one statistic.

Verify enough ordered history exists for the forecast components.

Describe associations and uncertainty without claiming causation.

An analytical overlay is only as sound as the population, scope, and assumptions supplied to it.