Map layers in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct map layer combination for showing sales by region with city markers

You want to create a Tableau map showing total sales by region as colored areas and individual city sales as points on top. Which combination of map layers should you use?

A Density Map for regions + Line Map for cities

B Symbol Map for regions + Filled Map for cities

C Filled Map for regions + Symbol Map for cities

D Line Map for regions + Filled Map for cities

💡 Hint

Think about which map type colors areas and which shows points.

Filled Maps color entire regions, perfect for showing sales by region. Symbol Maps show points, ideal for city-level sales markers.

🧠 Conceptual

intermediate

Understanding map layer order impact in Tableau

In Tableau, why does the order of map layers matter when you add multiple layers like filled regions and point markers?

A Because map layers change the data source order

B Because Tableau only allows one map layer at a time

C Because layers automatically merge colors regardless of order

D Because layers on top can hide layers below, affecting visibility

💡 Hint

Think about what happens if points are behind colored areas.

Map layers stack visually. If point markers are below filled regions, they may be hidden. The top layer is always visible above lower layers.

❓ dax_lod_result

advanced

Calculate total sales per state ignoring city filter using LOD expression

Given a dataset with sales by city and state, which Tableau LOD expression correctly calculates total sales per state ignoring any city-level filters?

Tableau

{FIXED [State] : SUM([Sales])}

A {FIXED [State] : SUM([Sales])}

B {EXCLUDE [City] : SUM([Sales])}

C {INCLUDE [City] : SUM([Sales])}

D SUM([Sales])

💡 Hint

Think about which LOD keyword fixes the calculation at the state level.

{FIXED [State] : SUM([Sales])} calculates sales fixed at the state level, ignoring city filters. INCLUDE adds detail, EXCLUDE removes detail, and SUM is affected by filters.

🔧 Formula Fix

advanced

Identify the error in layering map marks in Tableau

You created a map with two layers: a filled map for states and a symbol map for cities. The city points are not visible. What is the most likely cause?

A The symbol map layer is below the filled map layer, hiding the points

B The data source does not contain city coordinates

C The filled map layer has no color assigned

D The map projection is incorrect

💡 Hint

Consider layer stacking order and visibility.

If the symbol map layer is below the filled map layer, the city points will be hidden behind the colored regions. Adjusting layer order fixes this.

🎯 Scenario

expert

Design a multi-layer map dashboard for sales insights

You need to build a Tableau dashboard showing: (1) sales by state as colored areas, (2) top 5 cities by sales as large points, and (3) a heatmap layer showing sales density. How should you layer these map types for best clarity?

A Heatmap layer at bottom, filled map in middle, symbol map on top

B Filled map at bottom, heatmap in middle, symbol map on top

C Symbol map at bottom, filled map in middle, heatmap on top

D Filled map at bottom, symbol map in middle, heatmap on top

💡 Hint

Think about which layers provide background context and which highlight points.

The filled map provides a base color for states, so it should be at the bottom. The heatmap shows density and should be above the base but below points. The symbol map highlights top cities and should be on top for visibility.

Practice

1. What is the main purpose of Map Layers in Tableau?

easy

A. To combine different types of data on a single map

B. To create bar charts from map data

C. To export maps as images

D. To filter data in tables

Solution

1. Step 1: Understand the role of Map Layers

   Map Layers allow you to add multiple data types like points, colors, or shapes on one map.

2. Step 2: Differentiate from other features

   Map Layers are not for charts, exporting, or filtering tables but for combining map data visually.

3. Final Answer:

   To combine different types of data on a single map -> Option A

4. Quick Check:

   Map Layers = Combine data on map [OK]

Hint: Map Layers = multiple data types on one map [OK]

Common Mistakes:

• Confusing Map Layers with chart creation
• Thinking Map Layers export maps
• Assuming Map Layers filter tables

2. Which Tableau pane do you use to control the background details of a map?

easy

A. Filters shelf

B. Data pane

C. Marks card

D. Map Layers pane

Solution

1. Step 1: Identify the pane for background map control

   The Map Layers pane lets you toggle streets, borders, and other background details on or off.

2. Step 2: Differentiate from other panes

   The Data pane holds data fields, Marks card controls data visualization marks, and Filters shelf filters data, not background map details.

3. Final Answer:

   Map Layers pane -> Option D

4. Quick Check:

   Background control = Map Layers pane [OK]

Hint: Background map details = Map Layers pane [OK]

Common Mistakes:

• Using Data pane for map backgrounds
• Confusing Marks card with background control
• Trying to filter background layers

3. Given a Tableau map with a filled map layer and a point layer added via the Marks card, what will happen if you remove the point layer from the Marks card?

medium

A. The filled map layer will disappear

B. Only the point markers will disappear, filled map remains

C. Both layers will remain unchanged

D. The map will switch to a table view

Solution

1. Step 1: Understand layers added via Marks card

   Each layer added via the Marks card is independent; removing one removes only that layer.

2. Step 2: Effect of removing point layer

   Removing the point layer removes only the points; the filled map layer remains visible.

3. Final Answer:

   Only the point markers will disappear, filled map remains -> Option B

4. Quick Check:

   Remove point layer = points gone, fill stays [OK]

Hint: Removing one Marks layer removes only that layer [OK]

Common Mistakes:

• Assuming all layers disappear together
• Thinking map switches to table view
• Believing filled map depends on points

4. You added a polygon layer to your Tableau map but it does not display. What is the most likely cause?

medium

A. The Map Layers pane is turned off

B. You forgot to add a filter to the polygon layer

C. The polygon data is not properly connected or lacks geographic roles

D. Tableau does not support polygon layers

Solution

1. Step 1: Check data connection and geographic roles

   Polygon layers require properly connected data with geographic roles assigned to draw shapes.

2. Step 2: Eliminate other causes

   Map Layers pane controls background, not polygon visibility; filters are optional; Tableau supports polygons.

3. Final Answer:

   The polygon data is not properly connected or lacks geographic roles -> Option C

4. Quick Check:

   Polygon missing = data or geographic roles issue [OK]

Hint: Polygon layers need geographic roles assigned [OK]

Common Mistakes:

• Turning off Map Layers pane expecting polygons to show
• Assuming filters are mandatory for polygons
• Believing Tableau can't show polygons

5. You want to create a map showing sales by state with colored filled areas and overlay customer locations as points. Which steps correctly use Tableau's Map Layers feature?

hard

A. Use the Marks card to create a filled map for sales, then add a point layer for customers; adjust Map Layers pane for background details

B. Create two separate worksheets, one for sales and one for customers, then combine them in a dashboard

C. Use only the Map Layers pane to add both sales and customer data layers

D. Add sales data as points and customer data as filled areas using the Filters shelf

Solution

1. Step 1: Use Marks card for multiple layers

   Create a filled map layer for sales by state, then add a point layer for customer locations on the same map using the Marks card.

2. Step 2: Adjust background with Map Layers pane

   Use the Map Layers pane to control background map details like streets or borders for better visualization.

3. Final Answer:

   Use the Marks card to create a filled map for sales, then add a point layer for customers; adjust Map Layers pane for background details -> Option A

4. Quick Check:

   Marks card layers + Map Layers pane = correct layering [OK]

Hint: Marks card for data layers, Map Layers pane for background [OK]

Common Mistakes:

• Trying to add data layers only via Map Layers pane
• Using separate worksheets instead of layers
• Misusing Filters shelf for map layers