Reference bands in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a sales dashboard that highlights monthly sales performance with clear visual cues showing average sales and target sales ranges using reference bands.

📊 Data: You have monthly sales data for the current year including Month, Sales Amount, and Sales Target columns.

🎯 Deliverable: Create a Tableau dashboard with a line chart of monthly sales and add reference bands for average sales and target sales range.

Sample Data

Month	Sales Amount	Sales Target
January	12000	15000
February	14000	15000
March	13000	15000
April	16000	15000
May	17000	15000
June	15000	15000
July	18000	15000
August	19000	15000
September	20000	15000
October	21000	15000
November	22000	15000
December	23000	15000

1

Step 1: Connect your sales data to Tableau and open a new worksheet.

Import the data source containing Month, Sales Amount, and Sales Target columns.

Expected Result

Data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a line chart showing monthly sales.

Drag 'Month' to Columns shelf and 'Sales Amount' to Rows shelf. Change 'Month' to discrete if needed to show all months.

Expected Result

A line chart appears showing sales amount for each month.

3

Step 3: Add a reference band for average sales across all months.

Right-click on the vertical axis, select 'Add Reference Line'. In the dialog, select 'Band', set Scope to 'Entire Table', From 'Average of Sales Amount' to 'Average of Sales Amount', Label to 'Average Sales', and set a light color fill.

Expected Result

A shaded band appears on the chart representing the average sales value.

4

Step 4: Add a reference band showing the sales target range.

Add another reference band on the vertical axis. Set Scope to 'Entire Table', set band from 'Minimum of Sales Target' to 'Maximum of Sales Target', label it 'Target Range', and choose a distinct color fill with some transparency.

Expected Result

A second shaded band appears showing the target sales range across all months.

5

Step 5: Format the chart for clarity and add a title.

Add chart title 'Monthly Sales with Average and Target Bands'. Adjust colors for good contrast and ensure labels are readable.

Expected Result

The chart clearly shows monthly sales line with two reference bands and a descriptive title.

Final Result

Average Sales Band

(17,500)

↓

Target Range

Target Range

✓Sales consistently exceed the average sales band from July onwards.

✓The sales target is constant at 15000 each month, shown by the target range band.

✓Months January to March have sales below the target range.

✓From July to December, sales are well above the target range, indicating strong performance.

Bonus Challenge

Add a reference line showing the median sales and compare it with the average sales band.

Show Hint

Use 'Add Reference Line' on the vertical axis, select 'Median' aggregation for Sales Amount, and choose a contrasting color line.