Dimensions vs measures concept in Tableau - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a dimension field in Tableau.

Tableau

IF [Category] = [1] THEN "Selected" ELSE "Other" END

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

AAVG([Profit])

B"Furniture"

CSUM([Sales])

DCOUNT([Orders])

Attempts:

3 left

💡 Hint

Common Mistakes

Using aggregation functions like SUM or AVG for dimensions.

Not using quotes around text values.

Dimensions are categorical fields like 'Category'. Here, we compare the Category to a text value.

2fill in blank

medium

Complete the code to calculate total sales as a measure in Tableau.

Tableau

[1]([Sales])

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

ACOUNT

BMIN

CMAX

DSUM

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which counts rows, not sums values.

Using MIN or MAX which find smallest or largest values.

Measures are numeric and can be aggregated. SUM adds all sales values.

3fill in blank

hard

Fix the error in this calculated field to correctly create a measure for average profit.

Tableau

AVG([1])

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

A[Profit]

BSUM([Profit])

C"Profit"

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting square brackets around field names.

Using quotes around field names.

Using aggregation inside aggregation.

Measures require field names in square brackets in Tableau formulas.

4fill in blank

hard

Fill both blanks to create a calculated field that classifies sales as 'High' if above 1000, else 'Low'.

Tableau

IF [1] > [2] THEN "High" ELSE "Low" END

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

A[Sales]

B1000

C[Profit]

D500

Attempts:

3 left

💡 Hint

Common Mistakes

Using [Profit] instead of [Sales].

Using the wrong threshold number.

We compare the measure [Sales] to the number 1000 to classify sales levels.

5fill in blank

hard

Fill all three blanks to create a calculated field that returns the profit ratio if sales are positive, else zero.

Tableau

IF [1] > 0 THEN [2] / [3] ELSE 0 END

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

A[Sales]

B[Profit]

D[Quantity]

Attempts:

3 left

💡 Hint

Common Mistakes

Using quantity instead of sales in the denominator.

Checking profit instead of sales in the condition.

The formula checks if sales are positive, then divides profit by sales to get the ratio.