Map Issues - Card Builder

How do I create county and zip code drilldown in a U.S. map?

You can create U.S. maps in which users can drill down on states to see values by both county and zipcode. For example, a U.S. map may show sales for western states, as follows:

In this map, a user could click on the state of Oregon to show the sales for all of the counties in Oregon:

He or she could then click on Multnomah County (the small dark red county containing the city of Portland) to show sales by zip code within that county:

To enable state and county drilldown, you must first create a DataFlow data source that joins two datasources—the data source with the values you want to show, and a data source with state, county, and zipcode information. With this data source, you can create a U.S. map with state and county drilldown enabled.

Creating the data source

The first step in building a map with drilldown is creating a data source with your values matched to the appropriate states, counties, and zip codes.

Creating map drilldown

With your new data source, you can now build a U.S. map with state- and county-level drill path.

To create a map with drill path:

1. In the page where you want the new card to appear, click Add Card.

1. Click Design.

1. Click Existing Data.

1. Locate and select the data source you created in the previous set of steps.

1. Click Select Data Source.  The Visualize your Data screen appears,

1. Select United States as your chart type.

1. In the value menu, select the column that contains the values you want to display.

1. In the category menu, select State.

1. Click Save & Finish.  The card is saved to the card page.

1. Click the new card to open its Details

1. In the Gear menu, select Edit Drill Path.

1. Click Add a view.

1. In the category menu, select FIPS.

1. Click Save this View.

1. Click Add a view.

1. In the category menu, select ZipCode.

1. Click Save this View.

The drilldown map is now complete. You can test it by returning to the Details view and clicking on a state. If the drill path was implemented correctly, a state-level view appears with counties showing. You can then click a county to show the zip code areas within that county.

@smurray, @Rich  I'm afraid i'm just being obtuse.  I have a dataset that has state code, has fips code, and i think has zip-code (not so worried about the latter for the moment).  I have a card that is top view of states.  I have a drill-down built beneath that based on FIPS, howwever when i click the state level to initiate a drill-down, what i see is the US Counties map for the entirety of the country, but only values are highlighted for the selected state.  So of course the counties are infinitesimally small.  

What are the mechanics to adjust the configuration so that when I click on Oregon (the example shown in this thread), I only see Oregon's counties, and not just highlighted counties for Oregen off in the corner of the entire United States county-level map?

Thank you!

@ckatzman

I think you are saying you see this:

and what you want to see is this:

To get the top view you change the card type to the US Counties map. 

To get the bottom view you leave it as a US State Map, just like in the top level and you change the State Name field to the FIPS value. Like so:

The Top level should be set to State.

@ecenteno, did any of the above replies help you out?

Guys,

Once Support addresses this let's update the thread with their recommendation. @AaronS Thanks for taking to the time to get on the phone with @ckatzman.

Regards,

Dani

Thanks for your solution. but i want to clear the term "State" is what should it contains ? full state name like "Colorado" or just State Abbr like "CO"?