Study guide
7.3 Parameters, Parameter Actions & Dynamic What-If Analysis
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.3 Parameters, Parameter Actions & Dynamic What-If Analysis
Key Takeaways Explain This Topic AI
A Parameter is a global, workbook-level independent variable that can replace a constant value in calculations, filters, reference lines, and Top N set definitions.
Parameters are completely inert on their own; they do not alter a visualization until explicitly wired into a calculated field, filter, or reference line.
Parameters support six distinct data types: Float, Integer, String, Boolean, Date, and Date & Time, with allowable values configured as All, List, or Range.
Dynamic Parameters automatically refresh their allowable value list or initial default value from a designated data source field whenever the workbook opens.
Parameter Actions dynamically inject mark values into target parameters upon user interaction, enabling dynamic dimension/measure swapping via CASE calculations.
Last updated: September 2026
7.3 Parameters, Parameter Actions & Dynamic What-If Analysis
While filters restrict data rows and calculated fields manipulate values within columns, Parameters occupy a distinct architectural tier in Tableau: they are global, workbook-level independent variables . A parameter acts as an interactive constant that users can adjust to inject dynamic values into calculations, filters, reference lines, and SQL queries.
Parameters empower analysts to build flexible, interactive experiences—such as allowing executives to toggle between sales and profit, adjust a what-if sales growth slider from 0% to 25%, or dynamically choose how many top performers to view. For the Salesforce Certified Tableau Data Analyst, understanding parameter mechanics, allowable value constraints, Dynamic Parameters, and Parameter Actions is essential.
The Architecture of Parameters
Unlike dimensions and measures, which are bound to specific data source columns, parameters are data source agnostic . A single parameter created in a workbook can be referenced simultaneously across multiple distinct data sources, worksheets, calculations, and dashboard actions.
The Three Components of Parameter Implementation
A common exam question tests why a newly created parameter does not affect a worksheet. A parameter has zero operational effect on its own. Every parameter requires three coordinated steps: Step 1: CREATE THE PARAMETER
- Define Name, Data Type (Float, String, etc.), and Allowable Values (All, List, Range).
- |
- v
- Step 2: REFERENCE THE PARAMETER
- Wire the parameter into a Calculated Field, Top N Filter, or Reference Line.
- |
- v
- Step 3: EXPOSE THE PARAMETER CONTROL
- Show the parameter control card on the worksheet or dashboard for user interaction.
If an analyst creates a parameter and displays the control card on a dashboard, changing the control does nothing until a calculation or filter references that parameter!
Supported Data Types
Tableau parameters support six distinct data types:
Float (Decimal): Used for financial rates, percentages, multiplier factors (e.g., 0.05 for 5% tax).
Integer: Used for Top N rankings, thresholds, bin sizing, and discrete counts.
String: Used for menu pickers, dimension/measure swappers, and text-based branching.
Boolean: Used for binary toggles (True/False, Show/Hide).
Date: Used for threshold dates, historical cutoffs, and baseline comparisons.
Date & Time: Used for high-precision timestamp event cutoffs.
Allowable Values Configurations
All: Unrestricted entry. The user can type any valid value matching the data type into an open input box.
List: A predefined enumeration of values. Authors can configure a Display As alias (e.g., Value: 1 , Display As: Summary View ; Value: 2 , Display As: Detailed View ).
Range: Bounded numeric or date entry defined by Minimum, Maximum, and Step Size. In the user interface, ranges can render as an interactive Slider or a typed input box.
Dynamic Parameters: Refresh on Workbook Open
Historically, Tableau parameters were static: if an author populated a parameter list from [Category] or [Order Date] , any new products or dates added to the database required manual editing of the parameter list. In Tableau 2020.1, Tableau introduced Dynamic Parameters . Dynamic Parameter Configuration Dialog:
- +-------------------------------------------------------------+
- | Value when workbook opens: [ Max Date Calculation |v] |
- | |
- | Allowable values: ( ) All (*) List ( ) Range |
- | List options: |
- | (*) When workbook opens: [ Customer Region Field |v] |
- +-------------------------------------------------------------+
- Two Core Dynamic Behaviors
Value When Workbook Opens: Instead of hardcoding the parameter's initial value, the author can bind it to a calculated field. For example, setting the default value to {MAX([Order Date])} ensures that whenever an executive opens the workbook, the date parameter automatically defaults to the most recent date in the extract.
When Workbook Opens (List Refresh): Under Allowable Values > List, selecting 'When workbook opens' and choosing a data source field repopulates the allowable list from that field's current domain when the workbook opens. Test the current value and fallback behavior if a previously selected value is no longer present.
Dynamic Top N Filtering with Parameters
A classic parameter pattern is empowering end-users to dynamically adjust the number of top-performing dimension members displayed on a chart.
Implementation Workflow
Create an Integer Parameter named [Top N Selection] . Set Allowable Values to Range (Minimum: 5, Maximum: 50, Step size: 5).
Drag [Customer Name] to the Filters shelf.
In the Filter dialog, navigate to the Top tab.
Select By field -> choose Top -> click the numeric dropdown and select [Top N Selection] -> by SUM([Sales]) .
Expose the Parameter Control on the dashboard.
Important
Order of Operations Reminder: Because this Top N filter evaluates in Step 4 , remember that any secondary filters (such as [Department] or [Region] ) must be added to Context (Step 3) if the end-user expects to see the Top N customers within that specific department or region .
Dynamic Dimension and Measure Swapping
To prevent dashboard clutter and eliminate the need for sheet swapping across multiple views, analysts use parameters paired with CASE statements to allow users to switch which dimension or measure is rendered on an axis.
1. Dynamic Measure Selection
Create a String Parameter named [Select Measure] with List values: 'Sales' , 'Profit' , 'Profit Ratio' , and 'Quantity' . // Calculated Field: [Dynamic Measure Metric]
- CASE [Select Measure]
- WHEN 'Sales' THEN SUM([Sales])
- WHEN 'Profit' THEN SUM([Profit])
- WHEN 'Profit Ratio' THEN SUM([Profit]) / SUM([Sales])
- WHEN 'Quantity' THEN SUM([Quantity])
- END
Place [Dynamic Measure Metric] on Columns or Rows. When the user changes the parameter dropdown, the axis dynamically recalculates and re-renders.
Warning
Critical Exam Rule: Calculation Data Type Consistency: In Tableau, every branch of a CASE or IF-THEN statement must return the exact same data type and aggregation state . You cannot return a string in one branch ( WHEN 'Region' THEN [Region] ) and a numeric measure in another ( WHEN 'Sales' THEN SUM([Sales]) ). Furthermore, all branches must be aggregated if any branch is aggregated.
2. Dynamic Dimension Selection
Create a String Parameter named [Select Dimension] with List values: 'Category' , 'Region' , 'Segment' , and 'Ship Mode' . // Calculated Field: [Dynamic Dimension Field]
- CASE [Select Dimension]
- WHEN 'Category' THEN [Category]
- WHEN 'Region' THEN [Region]
- WHEN 'Segment' THEN [Segment]
- WHEN 'Ship Mode' THEN [Ship Mode]
- END
Place [Dynamic Dimension Field] on the Rows shelf. The table's visual headers now change dynamically based on user selection.
Parameter Actions on Dashboards
Parameter Actions eliminate the disconnect between the canvas and control widgets. Instead of forcing users to locate a dropdown menu in a corner container, a Parameter Action allows clicking a mark on a chart to update a parameter's value directly.
Configuration Options
Under Dashboard > Actions > Add Action > Change Parameter , the author configures:
Source Sheets: Worksheet where the click or hover occurs.
Run Action On: Hover , Select , or Menu .
Target Parameter: The parameter to update.
Source Field: The specific dimension or measure from the selected mark whose value will be injected into the target parameter.
Aggregation: When passing a measure, specifies the aggregation type (SUM, AVG, MIN, MAX).
Clearing the Selection Will: Specifies behavior when deselecting: Keep current value or Set value to (a designated default).
Practical Use Case: Interactive Baseline Comparison
An analyst creates an interactive timeline of stock prices. When the user clicks any date mark on the timeline, a Parameter Action injects that date into [Baseline Date Parameter] . A calculated field computes the percentage change of all other dates relative to that selected baseline date: (SUM([Price]) - AVG([Baseline Price])) / AVG([Baseline Price]) . The entire dashboard immediately recalibrates to show performance relative to the clicked event.
What-If Sensitivity and Scenario Analysis
Parameters are the foundation of what-if sensitivity modeling. Analysts can simulate business outcomes without modifying underlying database records. // Calculated Field: [Projected Revenue]
SUM([Sales]) * (1 + [Annual Growth Rate Parameter])
- // Calculated Field: [Net Profit Under Revised Tariff]
- SUM([Revenue]) - (SUM([Cost of Goods Sold]) * (1 + [Tariff Increase Parameter]))
By exposing floating slider controls for growth rates, tax rates, or pricing elasticity, stakeholders can run real-time stress tests directly on the dashboard.
Comparison Matrix: Parameters vs. Quick Filters vs. Sets
Feature Parameter Quick Filter Set
Scope Global: Workbook-wide, data source independent Local / Scoped: Sheet, selected sheets, or data source Data Source Bound: Bound to a single dimension
Selection Mode Single-Value Only: Cannot select multiple values Multi-Value or Single: Checkboxes, dropdowns, lists Binary Membership: Records are either IN or OUT
Formula Input Serves as an input variable inside calculated fields Cannot be referenced inside calculation syntax Can evaluate dynamic formulas in Condition tab
Data Types Float, Integer, String, Boolean, Date, Date/Time Bound to the data type of the filtered field Boolean ( IN / OUT )
Action Support Yes: Parameter Actions (Hover, Select, Menu) Yes: Filter Actions Yes: Set Actions
Dynamic Refresh Yes: Refreshes list or value on workbook open Yes: Native automatic query execution Yes: Dynamically evaluated in Step 4
Practical Pitfalls and Scenarios
Parameters are single-valued: A standard parameter cannot hold multiple non-contiguous regions simultaneously. Use a multi-value filter, set control, or set action when multi-selection is required.
An exposed control can still be inert: If changing the control does nothing, first confirm that the parameter is referenced by the worksheet's calculation, filter, reference line, or other supported feature. Also inspect action targeting and field logic before concluding that the parameter itself is defective.
CASE return types must be compatible: Mixing string outputs with numeric outputs, or incompatible aggregate and row-level branches, produces calculation errors.