Usage
view: view_name { dimension: field_name { map_layer_name: name_of_map_layer } }
Hierarchy
map_layer_name |
Possible Field Types
Dimension
Accepts
A map name specified in the model-level map_layer parameter
|
Basics
The map_layer_name
parameter lets you associate a dimension with a TopoJSON or GeoJSON map layer. This lets users create map charts by charting the values in the dimension on the map layer. For example, to be able to chart data by US state, you could associate a dimension called "State" to the built-in map layer us_states
. You could also chart data in a dimension called "Neighborhood" to a custom map of New York City neighborhoods.
If you are using a custom TopoJSON or GeoJSON map, you must specify the map layer in the LookML model by using the map_layer
parameter.
Dimensions of type: zipcode
automatically receive a map_layer_name
of us_zipcode_tabulation_areas
.
Built-in map layers
Looker includes the following built-in map layers:
countries
— Accepts full country names, ISO 3166-1 alpha-3 three-letter country codes, and ISO 3166-1 alpha-2 two-letter country codes. If your data includes ISO 3166-1 alpha-2 country codes, usingmap_layer_name
with thecountries
map is recommended to ensure that Looker interprets your data as country codes and not as state codes.uk_postcode_areas
— Accepts UK postcode areas (for example,L
for Liverpool,RH
for Redhill, orEH
for Edinburgh).us_states
— Accepts full state names and two-letter state abbreviations.us_counties_fips
— Works on string fields that are five-character FIPS county codes for a US county. This layer works only on the interactive map.us_zipcode_tabulation_areas
— Works on string fields that are five-character US zip codes. Dimensions oftype: zipcode
automatically use theus_zipcode_tabulation_areas
map layer.Zip code regions are based on the 2010 zip code tabulation areas (ZCTAs), so this map layer does not include many zip codes, such as those assigned to P.O. boxes, that do not map directly to regions.
Example
dimension: state {
map_layer_name: us_states
sql: ${TABLE}.state ;;
}