Reference lines in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a reference line at the average sales value.

Tableau

Add Reference Line: Value = [1](SUM([Sales]))

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

AAVG

BSUM

CMIN

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG for average calculation.

Using MIN or MAX which give minimum or maximum values.

The average sales value is calculated using the AVG aggregation function.

2fill in blank

medium

Complete the code to set the reference line label to show the exact value.

Tableau

Reference Line Label: [1]

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

ANone

BCustom

CValue

DComputation

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'None' which hides the label.

Choosing 'Custom' without specifying a custom label.

Choosing Value displays the exact value of the reference line on the chart.

3fill in blank

hard

Fix the error in the calculation to add a reference line at the median profit.

Tableau

Reference Line Calculation: [1]([Profit])

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

AMEDIAN

BAVG

CMEAN

DSUM

Attempts:

3 left

💡 Hint

Common Mistakes

Using MEAN which is not recognized in Tableau.

Using AVG which calculates average, not median.

The correct function to calculate the median is MEDIAN. 'MEAN' is not a valid Tableau function.

4fill in blank

hard

Fill both blanks to add a reference line at the maximum sales and set the line style to dashed.

Tableau

Add Reference Line: Value = [1]([Sales]), Line Style = [2]

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

AMAX

BSolid

CDashed

DMIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using MIN instead of MAX for maximum value.

Choosing Solid instead of Dashed for line style.

The maximum sales value is calculated with MAX. The dashed line style is set by Dashed.

5fill in blank

hard

Fill all three blanks to add a reference line at the average profit, set the label to custom text, and set the color to red.

Tableau

Add Reference Line: Value = [1]([Profit]), Label = [2], Color = [3]

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

AAVG

BCustom

CRed

DNone

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG for average.

Choosing 'None' for label which hides it.

Selecting a color other than Red.

Use AVG for average profit, Custom to set a custom label, and Red to color the line red.