Geographic roles assignment in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Geographic Roles in Tableau

In Tableau, assigning a geographic role to a data field helps Tableau recognize it as a location. Which of the following is NOT a valid geographic role you can assign to a field?

A State/Province

B City

C Currency

D Country/Region

💡 Hint

Think about what geographic roles represent: places or locations on a map.

Currency is a financial term, not a geographic location. Tableau's geographic roles include places like City, State/Province, Country/Region, Postal Code, etc.

❓ dax_lod_result

intermediate

Assigning Geographic Roles to Postal Codes

You have a dataset with a field named 'ZipCode' containing US postal codes. You want Tableau to recognize this field as a location on the map. What is the correct geographic role to assign?

A Postal Code

B Country/Region

C City

D Latitude

💡 Hint

Postal codes are numeric or alphanumeric codes used for mail delivery areas.

Postal Code is the geographic role that tells Tableau to interpret the field as postal codes for mapping.

❓ visualization

advanced

Visualizing Data with Incorrect Geographic Role

You assigned the geographic role 'Country/Region' to a field containing city names. What is the most likely outcome when you try to create a map visualization?

A Tableau will plot incorrect locations or aggregate all data into one point.

B Tableau will plot the cities correctly on the map.

C Tableau will show a blank map with no marks.

D Tableau will generate an error and prevent map creation.

💡 Hint

Think about what happens if Tableau misinterprets location data.

If the geographic role does not match the data, Tableau may plot wrong locations or aggregate data incorrectly because it tries to match city names as countries.

❓ data_modeling

advanced

Combining Geographic Roles for Hierarchical Mapping

You have three fields: 'Country', 'State', and 'City'. You want to create a drill-down map in Tableau that lets users explore data from country level down to city level. What is the best way to assign geographic roles to these fields?

A Assign 'City' to 'Country', 'State/Province' to 'State', and 'Country/Region' to 'City'.

B Assign 'Country/Region' to 'Country', 'State/Province' to 'State', and 'City' to 'City'.

C Do not assign any geographic roles; Tableau will detect automatically.

D Assign 'Country/Region' to all three fields.

💡 Hint

Think about the geographic hierarchy from larger to smaller regions.

Assigning the correct geographic roles matching the data type allows Tableau to build a geographic hierarchy for drill-down maps.

🔧 Formula Fix

expert

Troubleshooting Geographic Role Mismatch

You created a map visualization in Tableau using a field assigned the 'City' geographic role. However, many marks appear clustered in the wrong country. After checking, you find the city names are ambiguous (e.g., 'Springfield' exists in multiple states). What is the best way to fix this issue?

A Rename all city names to unique names manually.

B Change the geographic role of the city field to 'Country/Region'.

C Remove the city field and use only country-level data.

D Add the 'State' field with the 'State/Province' geographic role to the view to disambiguate cities.

💡 Hint

Think about how to provide more context to ambiguous location names.

Adding the 'State' field with the correct geographic role helps Tableau distinguish between cities with the same name in different states, improving map accuracy.