Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (47.2k points)

I know Tableau has mapping support for mapping congressional districts, but how do I do it? I currently have two fields in my table: [STATE] and [DISTRICT_NO].

I created a custom field that combines the two:

[STATE] + " " + STR([DISTRIC_NO])

which produces strings like: CA 2, IL 1, AZ 3.

I formatted the custom field to have a Geographic Role: Congressional District.

What am I missing?

1 Answer

0 votes
by (17.6k points)

  • There's a lot of Tableau Help files that show what mapping capabilities and I actually found one that provides an example! http://onlinehelp.tableausoftware.com/v8.0/pro/online/en-us/maps_geographicroles.html

  • U.S. Congressional District names. Boundaries are determined by data provided by each state's redistricting commission. Examples: 1st District, 2, District 3, 4th

  • It's still quite vague, but I got it to work by:

    • Set the number part, [DISTRICT_NO] as having a Geographic Role: Congressional District

    • Create a hierarchy that comprises [STATE] and [DISTRICT_NO]

You can check Tableau Desktop Specialist Certification program to learn more about tableau from basic to advance level. 

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...