Why calculations extend data analysis in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated field that sums sales.

Tableau

SUM([1])

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

ASales

BProfit

CQuantity

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Profit', 'Quantity', or 'Discount' instead of 'Sales'.

The SUM function adds all values in the 'Sales' field, which is common in data analysis.

2fill in blank

medium

Complete the code to calculate average profit per order.

Tableau

AVG([1])

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

ASales

BOrder ID

CQuantity

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Order ID' which is not numeric and cannot be averaged.

AVG calculates the average of the 'Profit' field, useful to understand profit per order.

3fill in blank

hard

Fix the error in the calculation to find profit ratio.

Tableau

SUM([1]) / SUM(Sales)

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

AQuantity

BDiscount

CProfit

DOrder ID

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Discount' or 'Quantity' which do not represent profit.

The profit ratio is total profit divided by total sales, so SUM(Profit) is correct.

4fill in blank

hard

Fill both blanks to create a calculated field for profit margin percentage.

Tableau

(SUM([1]) / SUM([2])) * 100

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

AProfit

BSales

CQuantity

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping profit and sales or using non-monetary fields.

Profit margin is profit divided by sales, multiplied by 100 to get a percentage.

5fill in blank

hard

Fill all three blanks to create a calculated field that counts orders with profit greater than zero.

Tableau

COUNT(IF [1] > [2] THEN [3] END)

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

AProfit

B0

COrder ID

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Sales' instead of 'Profit' in the condition.

Counting 'Sales' instead of 'Order ID'.

This counts orders where profit is greater than zero by checking 'Profit > 0' and counting 'Order ID'.