Introduction to parameters

Calculations in Tableau

Agata Bak-Geerinck

Senior Data Analyst, Telenet

What are parameters?

Parameter - a variable which can replace a constant value in a calculation, filter or reference line.

Mathematical formula 2x+1=y

  • Tableau parameters: number, date, string ...
  • Can be used in calculations
  • Inputs can be controlled by the user of your calculation or visualization
  • Help keep visualizations neat and organized
Calculations in Tableau

Types of parameters in Tableau

White spacing

Simple text field:

  • Frequently used names of products

Static list of values:

  • Using pre-defined measures as inputs
  • Limit filtering options to a few values

White spacing

Range of values:

  • Allowing to determine Top N value
  • Applying slider look-and-feel filtering

White spacing

A visual of a simple text field parameter

A visual of a static list parameter

A visual of a range parameter

Calculations in Tableau

Using parameters in calculations

  • Can be used in any calculation
  • Marked in purple font:

White spacing

A visual of calculation using a parameter

  • Remove the need to add new or manually edit the calculations:

Calculations in Tableau

Other uses of parameters

White spacing

Parameters in filters and titles

  • Top N calculations

A column chart with top 5 products, with dynamic title based on the parameter input

White spacing

Parameters in reference lines

  • Dynamic reference lines

A bar chart with a reference line controlled by a parameter

Calculations in Tableau

Making it even more interactive - parameter actions

Interactivity : the core of any dashboard or modern report

Parameter actions:

  • Allow to visually change a parameter's value
    • Based on click-selection
    • Based on hovering-over
  • Design customizable input controls
  • And much more!

White spacing

Visual of a dynamic

1 https://www.tableau.com/about/blog/2019/5/parameter-actions-extend-interactivity
Calculations in Tableau

Let's practice!

Calculations in Tableau

Preparing Video For Download...