Highlight tables in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a highlight table by dragging the correct mark type.

Tableau

SET mark_type = '[1]'

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

Aline

Bcircle

Csquare

Dbar

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'bar' or 'circle' mark types instead of 'square'.

Confusing highlight tables with bar charts.

In Tableau, to create a highlight table, you set the mark type to square.

2fill in blank

medium

Complete the code to assign the correct field to the Color shelf for a highlight table.

Tableau

Drag the [1] field to Color shelf.

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

AMeasure

BDate

CDimension

DCalculated field

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dimension field on Color shelf instead of a measure.

Not assigning any field to Color shelf.

Highlight tables use a measure on the Color shelf to show intensity of values.

3fill in blank

hard

Fix the error in the calculation to highlight sales above 5000.

Tableau

IF SUM([Sales]) [1] 5000 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 '=' which checks for equality.

Using '<' which checks for less than.

The correct operator to check if sales are above 5000 is >.

4fill in blank

hard

Fill both blanks to create a calculated field that highlights profit margin above 20%.

Tableau

IF [1] / [2] > 0.2 THEN 'Good' ELSE 'Bad' END

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

ASUM([Profit])

BSUM([Sales])

CAVG([Profit])

DAVG([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using average instead of sum.

Dividing sales by profit instead of profit by sales.

Profit margin is profit divided by sales, so use SUM([Profit]) divided by SUM([Sales]).

5fill in blank

hard

Fill all three blanks to create a highlight table that colors sales by region and category.

Tableau

Columns: [1]  Rows: [2]  Color: [3]

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

A[Region]

B[Category]

CSUM([Sales])

D[Customer Name]

Attempts:

3 left

💡 Hint

Common Mistakes

Putting a measure on Columns or Rows instead of dimensions.

Using a dimension for Color instead of a measure.

For a highlight table, put Region on Columns, Category on Rows, and color by SUM([Sales]) to show sales intensity.