Bird
Raised Fist0
Tableaubi_tool~10 mins

Reference bands in Tableau - Interactive Code Practice

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Practice - 5 Tasks
Answer the questions below
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.
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.
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.
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.
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.

Practice

(1/5)
1. What is the main purpose of adding a Reference Band in a Tableau chart?
easy
A. To add a title to the chart
B. To change the color of the entire chart background
C. To highlight a range of values on the axis for easy comparison
D. To filter out data points outside a specific range

Solution

  1. Step 1: Understand what a Reference Band does

    A Reference Band highlights a range on the axis, making it easier to see where data points fall within that range.

  2. Step 2: Compare options to the purpose

    Only To highlight a range of values on the axis for easy comparison describes highlighting a range for comparison, which matches the purpose of Reference Bands.

  3. Final Answer:

    To highlight a range of values on the axis for easy comparison -> Option C

  4. Quick Check:

    Reference Band = Highlight range [OK]
Hint: Reference bands highlight ranges, not filter or color whole chart [OK]
Common Mistakes:
  • Confusing reference bands with filters
  • Thinking reference bands change chart background color
  • Assuming reference bands add titles
2. Which of the following is the correct way to add a Reference Band in Tableau?
easy
A. Right-click the axis, select 'Add Reference Line', then choose 'Band'
B. Drag a measure to the Filters shelf and select 'Reference Band'
C. Click 'Worksheet' menu and select 'Add Reference Band' directly
D. Double-click the title and type 'Reference Band'

Solution

  1. Step 1: Recall the method to add Reference Bands

    In Tableau, Reference Bands are added by right-clicking the axis, selecting 'Add Reference Line', and then choosing 'Band'.

  2. Step 2: Evaluate each option

    Only Right-click the axis, select 'Add Reference Line', then choose 'Band' correctly describes this process. The other options describe incorrect or nonexistent steps.

  3. Final Answer:

    Right-click the axis, select 'Add Reference Line', then choose 'Band' -> Option A

  4. Quick Check:

    Add Reference Band = Right-click axis > Add Reference Line > Band [OK]
Hint: Always add reference bands via axis right-click menu [OK]
Common Mistakes:
  • Trying to add reference bands from Filters shelf
  • Looking for a direct menu option under Worksheet
  • Confusing reference bands with chart titles
3. Given a sales chart with a Reference Band set between $10,000 and $20,000, what will happen to sales values of $25,000?
medium
A. They will be highlighted inside the band
B. They will be outside the highlighted band range
C. They will be filtered out from the chart
D. They will change color to red automatically

Solution

  1. Step 1: Understand the Reference Band range

    The Reference Band highlights values between $10,000 and $20,000 only.

  2. Step 2: Analyze where $25,000 falls

    $25,000 is greater than $20,000, so it lies outside the band and will not be highlighted.

  3. Final Answer:

    They will be outside the highlighted band range -> Option B

  4. Quick Check:

    Value > band max = outside band [OK]
Hint: Values outside band range are not highlighted [OK]
Common Mistakes:
  • Assuming values above band max are highlighted
  • Thinking reference bands filter data
  • Believing colors change automatically without setup
4. You added a Reference Band but it does not appear on your Tableau chart. What is the most likely reason?
medium
A. You need to add a filter before adding a band
B. You forgot to refresh the data source
C. Reference Bands only work on pie charts
D. The band range is set outside the data's axis scale

Solution

  1. Step 1: Check Reference Band range vs axis scale

    If the band range is outside the visible axis scale, it won't show on the chart.

  2. Step 2: Evaluate other options

    Refreshing data or filters are unrelated to band visibility; Reference Bands work on many chart types, not just pie charts.

  3. Final Answer:

    The band range is set outside the data's axis scale -> Option D

  4. Quick Check:

    Band range inside axis scale = visible band [OK]
Hint: Ensure band range fits axis scale to see it [OK]
Common Mistakes:
  • Thinking data refresh affects band visibility
  • Believing bands only work on pie charts
  • Assuming filters are required before bands
5. You want to highlight sales performance between $15,000 and $30,000 on a line chart and also show the average sales as a reference line. How do you correctly set this up in Tableau?
hard
A. Add a Reference Band from $15,000 to $30,000 and add a Reference Line for average sales on the same axis
B. Add two Reference Bands: one for $15,000 to $30,000 and one for average sales
C. Add a Reference Line for $15,000 and another Reference Line for $30,000, then add average sales as a band
D. Add a filter to show only sales between $15,000 and $30,000 and add average sales as a color

Solution

  1. Step 1: Add Reference Band for sales range

    Use 'Add Reference Line' > 'Band' to highlight sales between $15,000 and $30,000.

  2. Step 2: Add Reference Line for average sales

    Add a separate Reference Line on the same axis to show the average sales value.

  3. Step 3: Confirm correct setup

    Add a Reference Band from $15,000 to $30,000 and add a Reference Line for average sales on the same axis correctly describes adding one band for the range and one line for average, which is the best practice.

  4. Final Answer:

    Add a Reference Band from $15,000 to $30,000 and add a Reference Line for average sales on the same axis -> Option A

  5. Quick Check:

    Band for range + line for average = correct setup [OK]
Hint: Use band for range and line for average on same axis [OK]
Common Mistakes:
  • Using two bands instead of band plus line
  • Confusing lines and bands roles
  • Filtering data instead of highlighting range