Statistical summary card in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated field that returns the average sales.

Tableau

AVG([1])

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

ASales

CSUM(Sales)

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM inside AVG causes errors.

Putting quotes around field names.

Using aggregation inside aggregation.

The AVG function calculates the average of the Sales field.

2fill in blank

medium

Complete the code to create a calculated field that returns the median profit.

Tableau

MEDIAN([1])

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

ASUM(Profit)

BAVG(Profit)

CProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM or AVG inside MEDIAN.

Adding quotes around field names.

Using aggregation inside aggregation.

The MEDIAN function calculates the middle value of the Profit field.

3fill in blank

hard

Fix the error in the calculated field to return the standard deviation of sales.

Tableau

STDEV([1])

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

ASales

BSUM(Sales)

CAVG(Sales)

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM or AVG inside STDEV.

Adding quotes around field names.

Using aggregation inside aggregation.

The STDEV function requires the field name without aggregation inside.

4fill in blank

hard

Fill both blanks to create a calculated field that returns the variance of profit for each category.

Tableau

WINDOW_VAR([1], 0, [2])

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

ASUM(Profit)

BProfit

CLAST()

DFIRST()

Attempts:

3 left

💡 Hint

Common Mistakes

Using aggregated fields inside WINDOW_VAR.

Using FIRST() instead of LAST() for window end.

Leaving blanks empty.

WINDOW_VAR calculates variance over a window. Use the field name Profit and LAST() to define the window end.

5fill in blank

hard

Fill all three blanks to create a calculated field that returns the coefficient of variation (CV) for sales.

Tableau

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

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

ASTDEV(Sales)

BSales

C100

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM(Sales) instead of STDEV(Sales) in numerator.

Not multiplying by 100 to get percentage.

Mixing aggregation functions incorrectly.

The coefficient of variation is standard deviation divided by average, multiplied by 100 to get a percentage.