Reference bands in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a reference band showing the average sales.

Tableau

REFERENCE BAND: Add a band at [1] of Sales

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

ASUM

BMIN

CAVG

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG will show total sales, not average.

Using MIN or MAX will show extremes, not the average.

The average (AVG) sales is used to create a reference band that shows the mean value across the data.

2fill in blank

medium

Complete the code to set the reference band scope to the entire table.

Tableau

Set reference band scope to [1]

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

ATable

BCell

CPane

DHeader

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Pane' limits the band to a section, not the whole table.

Choosing 'Cell' applies band only to individual cells.

Setting the scope to 'Table' applies the reference band across the entire table, not just a part.

3fill in blank

hard

Fix the error in the reference band calculation to show median sales.

Tableau

REFERENCE BAND: Add a band at [1] of Sales

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

AAVG

BMEAN

CMODE

DMEDIAN

Attempts:

3 left

💡 Hint

Common Mistakes

Using MEAN or AVG calculates average, not median.

MODE is not supported for reference bands in Tableau.

MEDIAN is the correct function to calculate the middle value of sales for the reference band.

4fill in blank

hard

Fill both blanks to create a reference band from minimum to maximum sales.

Tableau

REFERENCE BAND: Add a band from [1] to [2] of Sales

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

AMIN

BAVG

CMAX

DMEDIAN

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG or MEDIAN will not cover the full range.

Reversing MIN and MAX will cause incorrect band.

The band should start at the minimum (MIN) and end at the maximum (MAX) sales values.

5fill in blank

hard

Fill all three blanks to create a reference band with custom label and color.

Tableau

REFERENCE BAND: Add a band at [1] of Sales with label '[2]' and color [3]

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

AAVG

BAverage Sales

Cblue

DSUM

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG changes the meaning.

Using unclear or missing labels confuses viewers.

Choosing colors with poor contrast reduces visibility.

The band uses AVG for average sales, labels it 'Average Sales', and colors it blue for clear visibility.