Why combining chart types tells richer stories in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a combined measure by adding a second measure.

Tableau

SUM(Sales) [1] AVG(Profit)

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

A+

BAND

CWITH

DOR

Attempts:

3 left

💡 Hint

Common Mistakes

Using logical operators like AND or OR instead of arithmetic operators.

In Tableau, combining measures with a plus sign (+) in calculated fields can help create combined metrics for use in charts.

2fill in blank

medium

Complete the code to identify the Profit measure in a multi-measure chart.

Tableau

IF [1] THEN 'Synchronize Axis' ELSE 'Separate Axis' END

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

AMeasure Names = 'Sales'

BMeasure Names = 'Quantity'

CMeasure Names = 'Profit'

DMeasure Names = 'Discount'

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a measure not used in the chart.

In Tableau dual-axis charts with multiple measures, Measure Names can be used in calculations to check for specific measures like Profit.

3fill in blank

hard

Fix the error in the calculation to combine bar and line charts correctly.

Tableau

IF SUM(Sales) [1] 10000 THEN 'High' ELSE 'Low' END

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

A>

B=

C<=

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using equality (=) instead of greater than (>) causes wrong filtering.

The greater than (>) operator correctly filters sales above 10,000 to show 'High'.

4fill in blank

hard

Fill both blanks to create a calculated field that shows profit ratio and categorizes it.

Tableau

Profit Ratio = SUM(Profit) [1] SUM(Sales)
Category = IF Profit Ratio [2] 0.2 THEN 'Good' ELSE 'Needs Improvement' END

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

A/

B*

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using multiplication instead of division for ratio.

Profit Ratio is calculated by dividing profit by sales, and then compared if greater than 0.2 for category.

5fill in blank

hard

Fill all three blanks to create a combined chart with sales, profit, and a filter for high sales.

Tableau

Combined Sales = SUM([1])
Combined Profit = AVG([2])
Filter = IF SUM(Sales) [3] 50000 THEN 'High Sales' ELSE 'Low Sales' END

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

ASales

BProfit

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up measure names or using wrong comparison operators.

SUM(Sales) and AVG(Profit) are common aggregations, and filtering sales greater than 50,000 identifies high sales.