Lens

US Map Tile

A US Map tile shades each US state by one metric, from a dimension that holds state codes or names, so you can see where your results come from.

US Map tile shading California darkest, then Texas, New York and Florida; states with no orders stay grey.
Illustration with the numbers from the Example below

What it shows

A US Map tile colors each state by a metric, from light blue for low values to dark blue for high ones, with a High to Low scale on the right. States with no data stay grey. Alaska and Hawaii are drawn as small insets in the bottom left.

Use it forNot for
Where orders, leads or sessions come from, by stateCountries, provinces or cities (only US states are drawn)
Spotting regional gaps for geo-targeted campaignsExact rankings (add a Table tile grouped by state next to it)
A quick visual on an executive boardRates that need many rows per state combined (see Limits)

Example

Your table has a region dimension and an orders metric. The region values are mixed: CA, TX, US-NY, Florida, (not set) and ON.

SettingValue
TypeUS Map
Data Tableshop_orders
Metricorders
State Dimensionregion
region valueordersOn the map
CA1,200California, darkest blue
TX950Texas
US-NY800New York
Florida600Florida, lightest blue of the four
(not set)300Left out
ON40Left out, not a US state

The scale runs from 0 to 1,200. Every other state stays grey, and hovering one of them shows 0.

Data it needs

  • One metric.
  • A dimension holding US states. The editor asks for 2-letter codes, and the tile also accepts these forms, in any letter case:
FormExample
2-letter codeCA
Code with a US prefixUS-CA
Full state nameCalifornia

The 50 states and the District of Columbia are drawn. Territories such as Puerto Rico are not, and "Washington DC" written that way is not recognized: use DC or District of Columbia.

Settings

SettingWhat it doesDefault
TitleName shown on the tile. Required, up to 80 charactersEmpty
DescriptionOptional text behind an info icon on the tile, up to 500 charactersEmpty
SizeSmall, Third, Medium or Large. Medium or Large keeps the map readableMedium
Data TableThe Lens table the tile readsNone, required
MetricThe metric that colors the statesNone, required
State DimensionThe dimension that holds the state. RequiredNone
Date rangeInherit from board (default), Ignore (all available data), Relative range or Fixed datesInherit from board

How it calculates

  • Per state. The tile groups the table by the state dimension over the date range, then turns each value into a state. Values that point to the same state, such as CA and California, are added together.
  • Dropped values. Anything that is not one of the 50 states or DC is left out without a warning: blanks, "(not set)", other countries' region codes.
  • Color scale. From 0 to the highest state value. States with data are shaded along the scale. States with no data stay grey, so "no data" never looks like "low".
  • No data. On the board the map draws with every state grey. The public report shows "No data available".

What viewers can do

  • Hover a state to see its name and value.
  • Drag the handles on the High to Low scale to highlight only the states in a value range.
  • Change the board's dates and filter chips. Tiles set to Inherit follow them.
  • The map does not zoom, pan or drill down, and the board's comparison picker has no effect on it.
  • The public report shows the same map.

Limits and gotchas

  • Rates and unique counts can be off when one state has several values. If the dimension holds both CA and California, the two rows are simply added. That is right for counts and sums, but a conversion rate becomes the sum of two rates and a count of users can count a person twice. Clean the state values in the source data before mapping a rate.
  • Hovering a grey state shows 0. It means no data, not a measured zero.
  • No tile filters, Compare To or abbreviation. The editor does not offer them for this tile type. Use board filter chips to narrow it.
  • Outside the US is dropped silently. A table with mostly international traffic can look almost empty. Check the share of rows with a US state before reading too much into it.
  • City and country dimensions do not work. Point the tile at the state or region dimension.