View the original community article here
Last tested: Mar 10, 2020
Does your map look like this:
It looks like we have a map_layer properly defined. And we can even see our values populated in the legend of the visualization, but nothing populating for the states. The LookML looks legit like this:
dimension: state {
type: string
sql: ${TABLE}.state;;
map_layer_name: us_states
}
If we see this behavior, we should double check for whitespace in the underlying field. We can do this in the Explore by adding an `ends with` filter like the following:
Since we still have results, we know we have trailing whitespace in the State field which is preventing us from mapping the State values to the map_layer property_key.
The solution is to make a change in the underlying database or wrap the field in a TRIM() function like so:
dimension: state {
type: string
sql:TRIM(${TABLE}.state);;
map_layer_name: us_states
}
Then we should see these values plot as expected
Another case is for when we are filtering on the information that does match with Full country name and still not being populated. So, for the map layer dimension, there could be a mix of iso and full country names, but it is case sensitive and has to match the ISO specs.
This content is subject to limited support.