Geographic roles assignment in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample sales data by city and country for geographic visualization.

Cell	Value
A1	City
A2	New York
A3	Paris
A4	Tokyo
B1	Country
B2	USA
B3	France
B4	Japan
C1	Sales
C2	1000
C3	850
C4	900

Formula Trace

Assign Geographic Role 'City' to column 'City' for map visualization

Step 1: Select column 'City' in data pane

Step 2: Right-click 'City' column → Geographic Role → City

Step 3: Tableau matches city names to geographic coordinates

Step 4: Plot points on map using coordinates

Cell Reference Map

    A        B        C
1 | City   | Country | Sales
2 | New York| USA    | 1000
3 | Paris   | France | 850
4 | Tokyo   | Japan  | 900

[City column assigned geographic role 'City']

The 'City' column is assigned the geographic role 'City' to enable map plotting.

Result

Map View:
  • New York (1000)
  • Paris (850)
  • Tokyo (900)

Each dot represents a city placed on the map by Tableau using assigned geographic roles.

The final map shows points for each city positioned correctly using their geographic roles.

Sheet Trace Quiz - 3 Questions

What does assigning a geographic role to a column in Tableau do?

A It changes the data values to numbers.

B It tells Tableau to treat the data as geographic locations for mapping.

C It deletes the column from the data.

D It sorts the data alphabetically.

Key Result

Assigning a geographic role to a column enables Tableau to map data points based on recognized geographic locations.