Text tables in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a text table showing sales by region.

Tableau

SUM([1])

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

AQuantity

BProfit

CDiscount

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit instead of Sales will show profit values, not sales.

Using Quantity or Discount will not show sales amounts.

The SUM(Sales) aggregation sums the sales values, which is typical for a text table showing sales by region.

2fill in blank

medium

Complete the code to display the average profit per category in the text table.

Tableau

AVG([1])

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

ASales

BProfit

CQuantity

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales will show average sales, not profit.

Quantity and Discount are unrelated to profit averages.

The AVG(Profit) calculates the average profit per category, which is useful for analyzing profitability in a text table.

3fill in blank

hard

Fix the error in the calculation to show total quantity sold.

Tableau

SUM([1])

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

AQuantity

BProfit

CSales

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales or Profit will sum money amounts, not item counts.

Discount is unrelated to quantity sold.

The SUM(Quantity) correctly sums the total number of items sold, which is the intended calculation.

4fill in blank

hard

Fill both blanks to create a calculated field that shows profit ratio as a 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

Using Quantity or Discount in the denominator will give incorrect ratios.

Reversing numerator and denominator will invert the ratio.

The formula SUM(Profit) / SUM(Sales) * 100 calculates profit as a percentage of sales, which is the profit ratio.

5fill in blank

hard

Fill all three blanks to create a calculated field that shows average discount per quantity sold.

Tableau

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

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

ADiscount

BQuantity

C100

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales instead of Quantity will give incorrect per-unit calculation.

Not multiplying by 100 will leave the result as a decimal, not a percentage.

This formula SUM(Discount) / SUM(Quantity) * 100 calculates the average discount per unit sold as a percentage.