Parameter for top N control in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the calculation to create a parameter that controls the number of top products shown.

Tableau

IF RANK(SUM([Sales])) <= [[1]] THEN [Product Name] END

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

ACount

BTop10

CLimit

DTopN

Attempts:

3 left

💡 Hint

Common Mistakes

Using a fixed number instead of a parameter.

Using a parameter name that does not exist.

The parameter named TopN is used to control how many top products to display based on sales rank.

2fill in blank

medium

Complete the parameter control formula to filter the top N customers by sales.

Tableau

RANK(SUM([Sales])) <= [[1]]

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

AParameter1

BLimit

CTopN

DMaxValue

Attempts:

3 left

💡 Hint

Common Mistakes

Using a fixed number instead of a parameter.

Using a parameter name that is not defined.

The TopN parameter is used to dynamically control the number of top customers shown.

3fill in blank

hard

Fix the error in the calculation to correctly use the parameter for top N filtering.

Tableau

IF RANK(SUM([Profit])) <= [[1]] THEN [Category] END

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

ATopN

BTopNumber

CTop_N

DTop

Attempts:

3 left

💡 Hint

Common Mistakes

Using a parameter name with underscores or different casing.

Using a parameter that does not exist.

The parameter name must exactly match TopN as defined in the workbook.

4fill in blank

hard

Fill both blanks to create a calculated field that filters top N regions by sales using the parameter.

Tableau

IF RANK(SUM([[1]])) <= [[2]] THEN [Region] END

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

ASales

BProfit

CTopN

DQuantity

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong measure for ranking.

Using a fixed number instead of the parameter.

The calculation ranks regions by Sales and compares it to the TopN parameter to filter top regions.

5fill in blank

hard

Fill all three blanks to create a dynamic top N filter using parameter and rank on profit.

Tableau

IF RANK(SUM([[1]])) <= [[2]] THEN [[3]] END

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

AProfit

BTopN

CCategory

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up measure and dimension fields.

Using a fixed number instead of the parameter.

This calculation ranks by Profit, compares to the TopN parameter, and returns the Category field for filtering.