Map layers in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample data showing cities with their latitude, longitude, and population for mapping.

Cell	Value
A1	City
B1	Latitude
C1	Longitude
D1	Population
A2	New York
B2	40.7128
C2	-74.0060
D2	8419000
A3	Los Angeles
B3	34.0522
C3	-118.2437
D3	3980000
A4	Chicago
B4	41.8781
C4	-87.6298
D4	2716000

Formula Trace

MAP(Layers: Base Map + City Points + Population Heat)

Step 1: Base Map layer loads geographic map background

Step 2: Plot City Points using Latitude and Longitude from sample data

Step 3: Add Population Heat layer using Population values

Step 4: Combine all layers into one map visualization

Cell Reference Map

     A          B           C           D
1 | City     | Latitude | Longitude | Population |
2 | New York | 40.7128  | -74.0060  | 8419000   |
3 | Los Angeles | 34.0522  | -118.2437 | 3980000   |
4 | Chicago  | 41.8781  | -87.6298  | 2716000   |

The map layers use Latitude (B) and Longitude (C) to place points, and Population (D) to create heat intensity.

Result

[Map Visualization]
+---------------------------------------+
| Base Map: country and state borders   |
|                                       |
|   * (New York)                        |
|                                       |
|           * (Los Angeles)             |
|                                       |
|       * (Chicago)                     |
|                                       |
| Heat overlay: brighter near New York |
+---------------------------------------+

The final map shows a geographic base map with city points plotted and a heat layer representing population density.

Sheet Trace Quiz - 3 Questions

Which data columns are used to place city points on the map?

A City and Population

B City and Latitude

C Latitude and Longitude

D Longitude and Population

Key Result

Map layers combine base geographic map with data-driven layers like points and heat maps for visualization.

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