0 votes
1 view
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]

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...