Parameter in calculated fields in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to use the parameter 'SalesTarget' in the calculated field.

Tableau

IF [Sales] > [1] THEN 'Above Target' ELSE 'Below Target' END

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

A[Region]

B[Profit]

C[SalesTarget]

D[Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Using the parameter name without brackets

Using a different field instead of the parameter

The parameter 'SalesTarget' is referenced inside square brackets to use its value in the calculation.

2fill in blank

medium

Complete the code to create a calculated field that multiplies Sales by the parameter 'Multiplier'.

Tableau

[Sales] * [1]

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

A[Multiplier]

B[Discount]

C[Quantity]

D[Profit]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a field name instead of the parameter

Forgetting to use brackets around the parameter

The parameter 'Multiplier' is used inside brackets to multiply the Sales value.

3fill in blank

hard

Fix the error in the calculated field that compares Sales to the parameter 'TargetValue'.

Tableau

IF [Sales] > [1] THEN 'Goal Met' ELSE 'Goal Not Met' END

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

A[TargetValue]

B'TargetValue'

CTargetValue

D[SalesTarget]

Attempts:

3 left

💡 Hint

Common Mistakes

Using the parameter name without brackets

Using quotes around the parameter name

The parameter must be referenced inside square brackets to be recognized correctly.

4fill in blank

hard

Fill both blanks to create a calculated field that returns 'High' if Sales exceed the parameter 'Threshold', otherwise 'Low'.

Tableau

IF [Sales] [1] [2] THEN 'High' ELSE 'Low' END

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

A>

B<

C[Threshold]

D[Target]

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong comparison operator

Referencing a wrong parameter name

The comparison operator '>' is used to check if Sales are greater than the parameter 'Threshold' referenced inside brackets.

5fill in blank

hard

Fill all three blanks to create a calculated field that adjusts Sales by a parameter 'Adjustment' only if Sales are less than the parameter 'Limit'. Otherwise, return Sales unchanged.

Tableau

IF [Sales] [1] [2] THEN [Sales] * [3] ELSE [Sales] END

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

A<

B[Limit]

C[Adjustment]

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong comparison operator

Forgetting to use brackets around parameters

Multiplying by the wrong parameter

The condition checks if Sales are less than the parameter 'Limit'. If true, Sales are multiplied by the parameter 'Adjustment'. Both parameters are referenced inside brackets.