Combo charts (bar + line) in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a dual-axis chart by dragging the correct option to the blank.

Tableau

SUM(Sales) [1] AVG(Profit)

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

AAND

B+

C||

DWITH

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '||' to combine measures.

Trying to use SQL keywords like 'AND' or 'WITH' in Tableau calculations.

In Tableau, to create a dual-axis chart, you place two measures like SUM(Sales) and AVG(Profit) on the Rows or Columns shelf (represented here by a double pipe '||'), then right-click one axis and select Dual Axis. This allows combining bar and line charts.

2fill in blank

medium

Complete the step to synchronize axes by dragging the correct option to the blank.

Tableau

Right-click on the second axis and select '[1]' to align scales.

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

ASynchronize Axis

BEdit Axis

CDual Axis

DAdd Reference Line

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Dual Axis' instead of 'Synchronize Axis'.

Selecting 'Edit Axis' which only allows manual scale changes.

To make sure both axes use the same scale in a combo chart, you right-click the second axis and choose 'Synchronize Axis'.

3fill in blank

hard

Fix the error in the calculation to combine Sales and Profit for the combo chart.

Tableau

IF SUM(Sales) > 1000 THEN [1] ELSE SUM(Profit) END

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

AAVG(Sales)

BSUM(Sales)

CSUM(Profit)

DMIN(Sales)

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG(Sales) which changes aggregation type.

Returning SUM(Profit) in the THEN part which mismatches the condition.

The calculation must return the same type of aggregation for both branches. Using SUM(Sales) ensures consistency.

4fill in blank

hard

Fill both blanks to set the mark types for the combo chart.

Tableau

Drag [1] to Rows shelf and [2] to Rows shelf, then right-click second axis and select Dual Axis.

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

ASUM(Sales)

BAVG(Profit)

CCOUNT(Orders)

DMAX(Discount)

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT(Orders) or MAX(Discount) which are less common for combo charts.

Placing the same measure twice.

Combo charts typically use SUM(Sales) as bars and AVG(Profit) as lines to show different measures together.

5fill in blank

hard

Fill all three blanks to complete the steps for formatting the combo chart axes.

Tableau

Right-click [1] axis, select [2], then check [3] to match scales.

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

Aleft

Bright

CSynchronize Axis

DEdit Axis

EShow Header

FHide Header

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting the left axis instead of right.

Choosing 'Edit Axis' instead of 'Synchronize Axis'.

Hiding the axis header accidentally.

To format combo chart axes, right-click the right axis, select 'Synchronize Axis', and ensure 'Show Header' is checked to display the axis.