Creating parameters in Tableau - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a parameter that allows users to select a number.

Tableau

CREATE PARAMETER 'NumberSelector' AS [1];

Drag options to blanks, or click blank then click option'

ABoolean

BString

CDate

DInteger

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing String type when a number is needed.

Using Date type for numeric selection.

The parameter type should be Integer to allow number selection.

2fill in blank

medium

Complete the code to set the parameter's allowable values to a list of fixed options.

Tableau

CREATE PARAMETER 'RegionSelector' ALLOWABLE VALUES [1] ('East', 'West', 'North', 'South');

Drag options to blanks, or click blank then click option'

AList

BRange

CAll

DCustom

Attempts:

3 left

💡 Hint

Common Mistakes

Using Range instead of List for fixed options.

Using All which is not a valid allowable value type.

Use List to specify fixed options for the parameter.

3fill in blank

hard

Fix the error in the parameter creation code to correctly set the default value to 10.

Tableau

CREATE PARAMETER 'SalesThreshold' AS Integer DEFAULT [1];

Drag options to blanks, or click blank then click option'

A'10'

Bten

C10

D10.0

Attempts:

3 left

💡 Hint

Common Mistakes

Putting the number in quotes, making it a string.

Using a decimal number for an Integer parameter.

The default value should be a number without quotes for Integer type.

4fill in blank

hard

Fill both blanks to create a parameter that allows a range of dates from 2020-01-01 to 2020-12-31.

Tableau

CREATE PARAMETER 'DateRange' AS Date ALLOWABLE VALUES [1] ([2]);

Drag options to blanks, or click blank then click option'

ARange

B'2020-01-01', '2020-12-31'

C'2020-12-31', '2020-01-01'

DList

Attempts:

3 left

💡 Hint

Common Mistakes

Using List instead of Range for date ranges.

Reversing the start and end dates.

Use Range for dates and specify start and end dates in correct order.

5fill in blank

hard

Fill all three blanks to create a parameter named 'DiscountRate' of type Float with a default value of 0.05 and allowable values from 0.0 to 0.1.

Tableau

CREATE PARAMETER 'DiscountRate' AS [1] DEFAULT [2] ALLOWABLE VALUES [3] (0.0, 0.1);

Drag options to blanks, or click blank then click option'

AFloat

B0.05

CRange

DInteger

Attempts:

3 left

💡 Hint

Common Mistakes

Using Integer type for decimal values.

Setting default value outside the range.

The parameter type is Float, default value is 0.05, and allowable values are a Range.

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