Creating calculated fields in Tableau - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated field that adds 10 to the Sales value.

Tableau

SUM([Sales]) [1] 10

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

A*

B-

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using '-' instead of '+'

Using '*' or '/' which multiply or divide instead of adding

In Tableau, to add a number to a field, you use the plus sign +.

2fill in blank

medium

Complete the code to calculate the average of the Profit field.

Tableau

[1]([Profit])

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

ASUM

BAVG

CMIN

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG

Using MIN or MAX which find minimum or maximum values

The function AVG() calculates the average of a field in Tableau.

3fill in blank

hard

Fix the error in the calculated field to return 'High' if Sales is greater than 1000, otherwise 'Low'.

Tableau

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

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

A>

B=

C<

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' which checks for equality

Using '<' which checks for less than

The correct operator to check if Sales is greater than 1000 is >.

4fill in blank

hard

Fill both blanks to create a calculated field that returns the profit ratio as a percentage.

Tableau

([Profit] [1] [Sales]) [2] 100

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

A/

B*

C+

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' or '-' instead of '*' for percentage calculation

Multiplying before dividing

To calculate profit ratio percentage, divide Profit by Sales, then multiply by 100.

5fill in blank

hard

Fill all three blanks to create a calculated field that categorizes Sales into 'Low', 'Medium', or 'High'.

Tableau

IF [Sales] [1] 500 THEN 'Low' ELSEIF [Sales] [2] 1500 THEN 'Medium' ELSEIF [Sales] [3] 1500 THEN 'High' END

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

A<=

B<

C>

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators causing wrong category assignment

Mixing up '<' and '<=' operators

Use '<' to include less than 500 for Low, '<=' to include 1500 in Medium, and '>=' for High sales.