Size encoding in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the size encoding for the marks based on sales.

Tableau

SIZE() = [1]

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

ACOUNT([Orders])

BAVG([Profit])

CMIN([Discount])

DSUM([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG or MIN instead of SUM for size encoding.

Using COUNT which counts records, not the measure value.

Size encoding in Tableau is often set by summing a measure like Sales to show relative magnitude.

2fill in blank

medium

Complete the code to encode size by average profit per category.

Tableau

SIZE() = [1]

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

ASUM([Profit])

BAVG([Profit])

CCOUNTD([Category])

DMAX([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG which changes the meaning.

Using COUNTD which counts distinct categories, not a measure.

Average profit per category is best represented by AVG([Profit]) for size encoding.

3fill in blank

hard

Fix the error in the size encoding calculation to correctly represent total quantity.

Tableau

SIZE() = [1]

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

ASUM([Quantity])

BMIN([Quantity])

CAVG([Quantity])

DCOUNT([Quantity])

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG or MIN which do not represent total quantity.

Using COUNT which counts records, not sums values.

To represent total quantity for size encoding, SUM([Quantity]) is correct.

4fill in blank

hard

Fill both blanks to create a size encoding that shows total sales but only for orders with profit greater than 100.

Tableau

SIZE() = SUM(IF [1] THEN [2] ELSE 0 END)

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

A[Profit] > 100

B[Sales]

C[Profit] < 100

D[Quantity]

Attempts:

3 left

💡 Hint

Common Mistakes

Using profit less than 100 in the condition.

Summing quantity instead of sales.

The condition filters profits greater than 100, and sales are summed for size encoding.

5fill in blank

hard

Fill all three blanks to create a calculated field for size encoding that sums sales only for orders where quantity is greater than 5 and profit is positive.

Tableau

SIZE() = SUM(IF [1] AND [2] THEN [3] ELSE 0 END)

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

A[Quantity] > 5

B[Profit] > 0

C[Sales]

D[Discount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using discount instead of sales for sum.

Using incorrect conditions for quantity or profit.

The calculation sums sales only when quantity is greater than 5 and profit is positive, suitable for size encoding.