Filled maps (choropleth) in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a filled map by dragging the correct mark type.

Tableau

Drag the '[1]' mark type to the Marks card to create a filled map.

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

ACircle

BShape

CMap

DFilled Map

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Circle' or 'Shape' which create point maps, not filled maps.

Selecting 'Map' which is not a mark type option.

In Tableau, to create a filled map (choropleth), you must select the 'Filled Map' mark type on the Marks card.

2fill in blank

medium

Complete the step to add color to the filled map by dragging the correct field to Color.

Tableau

Drag the '[1]' field to the Color shelf on the Marks card to color the map by data.

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

ALongitude

BLatitude

CSales

DState

Attempts:

3 left

💡 Hint

Common Mistakes

Dragging geographic fields like Latitude or Longitude to Color, which won't color by data.

Using dimension fields like State which color by category, not intensity.

To color a filled map by data values, drag a measure like 'Sales' to the Color shelf.

3fill in blank

hard

Fix the error in the calculation to show percentage of total sales by region.

Tableau

Percentage Sales = SUM([Sales]) / [1]

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

ATOTAL(SUM([Sales]))

BSUM([Region])

CAVG([Sales])

DCOUNT([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Region]) which is invalid because Region is a dimension.

Using AVG or COUNT which do not give total sales.

The TOTAL() function computes the sum across the entire table, so dividing by TOTAL(SUM([Sales])) gives the percentage of total sales.

4fill in blank

hard

Fill both blanks to create a calculated field that shows sales difference from average sales.

Tableau

Sales Difference = (SUM([Sales]) [1] AVG([Sales])) [2] AVG([Sales])

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

A-

B+

C*

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using addition or multiplication instead of subtraction and division.

Mixing up the order of operations.

The formula subtracts the average sales from the sum of sales, then divides by average sales to get the relative difference.

5fill in blank

hard

Fill all three blanks to create a calculated field that flags regions with sales above average.

Tableau

IF SUM([Sales]) [1] AVG([Sales]) THEN '[2]' ELSE '[3]' END

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

A>

BAbove Average

CBelow Average

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for the comparison.

Swapping the labels for true and false cases.

This IF statement checks if sales are greater than average sales and labels the region accordingly.