Creating parameters in Tableau - Quick Revision & Summary

Recall & Review

beginner

What is a parameter in Tableau?

A parameter is a dynamic value that users can change to control aspects of a visualization, like filtering or calculations.

beginner

How do you create a parameter in Tableau?

Right-click in the Data pane, select 'Create Parameter', then set the name, data type, allowable values, and current value.

beginner

What types of values can a Tableau parameter hold?

Parameters can hold single values like integers, floats, strings, dates, or booleans.

intermediate

How can parameters be used in Tableau dashboards?

Parameters can be added as controls for users to interact with, changing filters, calculations, or reference lines dynamically.

intermediate

Can parameters in Tableau update automatically based on data changes?

No, parameters are static until a user changes them; they do not update automatically with data changes.

What is the first step to create a parameter in Tableau?

A Drag a field to the Filters shelf

B Open the Dashboard pane

C Create a calculated field

D Right-click in the Data pane and select 'Create Parameter'

To create a parameter, you start by right-clicking in the Data pane and choosing 'Create Parameter'.

Which of these data types can a Tableau parameter NOT hold?

A Integer

B String

C Image

D Date

Parameters cannot hold images; they hold simple data types like integers, strings, and dates.

How do users interact with parameters in a Tableau dashboard?

A By changing parameter controls added to the dashboard

B By editing the data source directly

C By refreshing the workbook

D By changing calculated fields

Users interact with parameters through controls placed on the dashboard to change values dynamically.

Can a Tableau parameter filter multiple fields at once?

A Yes, if used in calculated fields referencing those fields

B No, parameters only filter one field directly

C Yes, parameters automatically filter all fields

D No, parameters cannot be used for filtering

Parameters can filter multiple fields if used inside calculated fields that reference those fields.

What happens to a parameter value when the underlying data changes?

A The parameter deletes itself

B The parameter value stays the same until changed by the user

C The parameter resets to default

D The parameter updates automatically

Parameters do not update automatically; they keep their value until the user changes them.

Explain how to create and use a parameter in Tableau to let users select a sales target.

Think about setting up a number users can change and using it in a calculation.

Describe the difference between a parameter and a filter in Tableau.

Consider how each controls what data is visible or calculated.

Practice

1. What is the main purpose of creating a parameter in Tableau?

easy

A. To allow users to input a single value that can change calculations or filters

B. To store multiple values for grouping data

C. To create a static label on the dashboard

D. To automatically refresh data sources

Solution

1. Step 1: Understand what parameters do

   Parameters hold a single value that users can change to affect calculations or filters.

2. Step 2: Compare options with parameter purpose

   Only To allow users to input a single value that can change calculations or filters describes this interactive input feature correctly.

3. Final Answer:

   To allow users to input a single value that can change calculations or filters -> Option A

4. Quick Check:

   Parameter purpose = interactive single value input [OK]

Hint: Parameters hold one user-controlled value for interactivity [OK]

Common Mistakes:

• Thinking parameters store multiple values
• Confusing parameters with filters
• Assuming parameters refresh data automatically

2. Which of the following is the correct way to create a parameter in Tableau?

easy

A. Double-click a worksheet title

B. Drag a field to Rows shelf

C. Use the Show Me panel to add a parameter

D. Right-click in Data pane > Create > Parameter

Solution

1. Step 1: Recall Tableau parameter creation steps

   Parameters are created by right-clicking in the Data pane and selecting Create > Parameter.

2. Step 2: Eliminate incorrect options

   Dragging fields or using Show Me does not create parameters; double-clicking titles edits text.

3. Final Answer:

   Right-click in Data pane > Create > Parameter -> Option D

4. Quick Check:

   Parameter creation = right-click Data pane [OK]

Hint: Create parameters via Data pane right-click menu [OK]

Common Mistakes:

• Trying to create parameters from Show Me panel
• Dragging fields instead of creating parameters
• Editing worksheet titles instead of parameters

3. Given a parameter named Sales Threshold set to 1000, and a calculated field High Sales defined as IF [Sales] > [Sales Threshold] THEN 'Yes' ELSE 'No' END, what will be the result for a sale of 1200?

medium

A. 'Yes'

B. 'No'

C. 1200

D. Error

Solution

1. Step 1: Understand the parameter and calculation

   The parameter Sales Threshold is 1000. The calculation checks if sales are greater than this threshold.

2. Step 2: Evaluate the condition for sale of 1200

   1200 > 1000 is true, so the calculated field returns 'Yes'.

3. Final Answer:

   'Yes' -> Option A

4. Quick Check:

   1200 > 1000 = 'Yes' [OK]

Hint: Compare value to parameter in IF statement for result [OK]

Common Mistakes:

• Confusing parameter value with sales value
• Expecting numeric output instead of text
• Ignoring the IF condition logic

4. You created a parameter but the dashboard does not update when you change its value. What is the most likely reason?

medium

A. The parameter control is hidden

B. The data source is disconnected

C. The parameter is not used in any calculated field or filter

D. The parameter value is set to automatic

Solution

1. Step 1: Understand parameter behavior

   Parameters alone do not affect the dashboard unless used in calculations or filters.

2. Step 2: Identify why dashboard doesn't update

   If the parameter is unused, changing it has no effect, causing no dashboard update.

3. Final Answer:

   The parameter is not used in any calculated field or filter -> Option C

4. Quick Check:

   Unused parameter = no dashboard update [OK]

Hint: Use parameters in calculations or filters to see changes [OK]

Common Mistakes:

• Assuming parameter control visibility affects updates
• Blaming data source connection without checking parameter use
• Misunderstanding parameter value settings

5. You want to create a parameter that lets users select a discount percentage from 0% to 50% in steps of 5%. Which parameter settings should you choose?

hard

A. Data type: Boolean; Allowable values: True or False

B. Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5

C. Data type: Float; Allowable values: All; Minimum: 0; Maximum: 50

D. Data type: String; Allowable values: List; Values: '0%', '5%', '10%', ..., '50%'

Solution

1. Step 1: Determine data type and value range

   Discount percentages are numeric integers from 0 to 50 with steps of 5.

2. Step 2: Choose parameter settings matching requirements

   Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5 correctly sets integer type, range values, and step size of 5.

3. Final Answer:

   Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5 -> Option B

4. Quick Check:

   Integer range with step size = correct parameter setup [OK]

Hint: Use integer range with step size for numeric selection [OK]

Common Mistakes:

• Using string type instead of numeric for percentages
• Choosing 'All' allowable values without step size
• Using Boolean type for numeric selection