Why parameters add user-driven flexibility in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

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

Tableau

CREATE PARAMETER [1] AS INTEGER;

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

ASalesRange

BSUM(Sales)

CDateFilter

DRegionSelect

Attempts:

3 left

💡 Hint

Common Mistakes

Using an aggregation function as the parameter name.

Using a name that is too generic or unrelated.

The parameter name must be a simple identifier like SalesRange. Other options are either expressions or unrelated names.

2fill in blank

medium

Complete the code to use a parameter in a calculated field to filter sales above the selected value.

Tableau

IF SUM(Sales) > [1] THEN 'Above' ELSE 'Below' END

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

A[TotalSales]

B[RegionSelect]

C[DateFilter]

D[SalesRange]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a field name instead of a parameter.

Forgetting to use square brackets around the parameter.

The parameter [SalesRange] is used to compare sales values dynamically based on user input.

3fill in blank

hard

Fix the error in the parameter control code to allow user input of a date.

Tableau

CREATE PARAMETER [1] AS DATE;

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

ASalesRange

BDateSelect

CRegionFilter

DUserDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a name unrelated to dates.

Using a name that conflicts with existing fields.

The parameter name DateSelect clearly indicates it is for date selection, matching the DATE type.

4fill in blank

hard

Fill both blanks to create a calculated field that uses a parameter to switch between sales and profit.

Tableau

IF [1] = 'Sales' THEN SUM(Sales) ELSE [2] END

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

A[MeasureSelector]

BSUM(Profit)

CAVG(Profit)

DSUM(Quantity)

Attempts:

3 left

💡 Hint

Common Mistakes

Using an aggregation function as the parameter name.

Using average instead of sum for profit.

The parameter [MeasureSelector] controls the choice, and SUM(Profit) is the alternative measure.

5fill in blank

hard

Fill all three blanks to create a dynamic filter using a parameter for region selection.

Tableau

IF [Region] = [1] THEN [2] ELSE [3] END

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

A[RegionSelector]

BSUM(Sales)

C0

DSUM(Profit)

Attempts:

3 left

💡 Hint

Common Mistakes

Using profit instead of sales for the matched region.

Not returning zero for unmatched regions.

The parameter [RegionSelector] is compared to the region field. If matched, sales are summed; otherwise, zero is returned to exclude.