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.