Why maps visualize location data in Tableau - Formula Trace Breakdown

Sample Data

This data shows three cities with their latitude and longitude coordinates.

Cell	Value
A1	City
B1	Latitude
C1	Longitude
A2	New York
B2	40.7128
C2	-74.0060
A3	Los Angeles
B3	34.0522
C3	-118.2437
A4	Chicago
B4	41.8781
C4	-87.6298

Formula Trace

MAKEPOINT([Latitude], [Longitude])

Step 1: MAKEPOINT(40.7128, -74.0060)

Step 2: MAKEPOINT(34.0522, -118.2437)

Step 3: MAKEPOINT(41.8781, -87.6298)

Cell Reference Map

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

References: Latitude (B2:B4), Longitude (C2:C4) feed into MAKEPOINT function.

Latitude and Longitude columns provide location data for the map visualization.

Result

• New York plotted near east coast

↓

• Los Angeles plotted on west coast

↓

• Chicago plotted near Great Lakes

The map shows points placed accurately on the map for each city using their coordinates.

Sheet Trace Quiz - 3 Questions

What does the MAP function use to place points on the map?

A City names only

B Latitude and Longitude values

C Random numbers

D Population data

Key Result

MAKEPOINT function uses latitude and longitude pairs to plot points on a geographic map.

Practice

1. Why do maps help in visualizing location data in Tableau?

easy

A. Because maps show where data points are located geographically

B. Because maps only show numerical data trends

C. Because maps replace all other chart types

D. Because maps hide data details

Solution

1. Step 1: Understand the purpose of maps

   Maps are designed to display data points based on their geographic location.

2. Step 2: Relate to Tableau's mapping feature

   Tableau uses geographic fields to place data on maps, helping users see spatial patterns.

3. Final Answer:

   Because maps show where data points are located geographically -> Option A

4. Quick Check:

   Maps visualize location data by showing geographic points [OK]

Hint: Maps show data by location, not just numbers [OK]

Common Mistakes:

• Thinking maps only show numbers
• Believing maps replace all charts
• Assuming maps hide data

2. Which of the following is the correct way to create a map in Tableau using geographic data?

easy

A. Drag a geographic field like 'Longitude' to Columns and 'Latitude' to Rows

B. Drag a geographic field like 'City' to the Marks card and select Map

C. Drag a geographic field like 'Country' to Rows and then to Columns

D. Drag a numeric field to Filters and select Map

Solution

1. Step 1: Identify how Tableau plots maps

   Tableau uses Latitude and Longitude fields to position points on a map.

2. Step 2: Confirm correct field placement

   Longitude goes to Columns and Latitude goes to Rows to create a map view.

3. Final Answer:

   Drag a geographic field like 'Longitude' to Columns and 'Latitude' to Rows -> Option A

4. Quick Check:

   Longitude on Columns and Latitude on Rows creates maps [OK]

Hint: Longitude = Columns, Latitude = Rows for maps [OK]

Common Mistakes:

• Putting numeric fields in Filters to create maps
• Dragging geographic fields only to Marks card
• Swapping Latitude and Longitude incorrectly

3. Given a dataset with 'City', 'Sales', and 'Latitude' and 'Longitude' fields, what will happen if you drag 'Longitude' to Columns and 'Latitude' to Rows in Tableau?

medium

A. Tableau will produce an error

B. Tableau will create a bar chart of sales

C. Tableau will show a table of city names

D. Tableau will create a map showing sales by city location

Solution

1. Step 1: Understand field roles

   Latitude and Longitude fields define geographic points for mapping.

2. Step 2: Visualize Tableau's behavior

   Dragging Longitude to Columns and Latitude to Rows plots points on a map, showing locations.

3. Final Answer:

   Tableau will create a map showing sales by city location -> Option D

4. Quick Check:

   Latitude and Longitude create maps, not bar charts [OK]

Hint: Latitude and Longitude create maps, not charts [OK]

Common Mistakes:

• Expecting bar charts from geographic fields
• Confusing table view with map view
• Assuming error occurs without extra steps

4. You tried to create a map in Tableau by dragging 'City' to Rows and 'Sales' to Columns, but no map appeared. What is the likely problem?

medium

A. You must drag Latitude and Longitude fields to create a map

B. City is not recognized as a geographic field automatically

C. Sales is a geographic field and should not be on Columns

D. Tableau does not support maps with city data

Solution

1. Step 1: Check field geographic role

   City may not be set as a geographic role, so Tableau treats it as text.

2. Step 2: Understand Tableau mapping requirements

   Tableau needs geographic roles or Latitude/Longitude to plot maps.

3. Final Answer:

   City is not recognized as a geographic field automatically -> Option B

4. Quick Check:

   Geographic roles must be assigned for maps [OK]

Hint: Assign geographic roles to fields before mapping [OK]

Common Mistakes:

• Assuming Sales is geographic
• Thinking Latitude/Longitude always required
• Believing Tableau can't map cities

5. You want to visualize sales data by state on a map in Tableau, but your dataset only has state names and sales figures. What is the best way to create a map showing sales by state?

hard

A. Drag 'Sales' to Rows and 'State' to Columns to create a bar chart

B. Create calculated fields for Latitude and Longitude manually

C. Assign the 'State' field a geographic role of 'State/Province' and drag it to Detail on the Marks card

D. Use only numeric fields to create the map

Solution

1. Step 1: Assign geographic role to 'State'

   Tableau needs to know 'State' is a geographic field to map it.

2. Step 2: Use 'State' on Marks card Detail

   Dragging 'State' to Detail lets Tableau plot each state on the map automatically.

3. Final Answer:

   Assign the 'State' field a geographic role of 'State/Province' and drag it to Detail on the Marks card -> Option C

4. Quick Check:

   Geographic role + Detail = map by state [OK]

Hint: Assign geographic role and use Detail for location maps [OK]

Common Mistakes:

• Trying to create maps without geographic roles
• Using numeric fields only for maps
• Manually creating Latitude/Longitude unnecessarily