A figure at every site, on a map

An availability wall from one set of rules

A status map usually costs twice: once to colour the table, and again to colour the map, with two sets of thresholds that drift apart until a cell says amber and the dot beside it says green.

Here the rules live on the availability column, and both readings come from them. The figure printed beside each dot is the column’s own cell text, so a percentage reads as a percentage, an amount of money reads as money, and a unit reads as its unit, with the decimals you already chose. The fill is whatever rule that value matched. Change a cut point once and the table and the map both move, because there is only one place to change it.

The legend names the rules that actually matched, with each rule’s own label and swatch, so it reads as your policy rather than as a palette.

The map is a view of the grid, not a copy of it

Narrow the table to one region and the map redraws to that region. Sort it, edit a reading, point the grid at a live feed: the markers follow, the same way every other chart here does. Click a marker and its row is selected in the table below, so a dot on the other side of the world and the line of detail behind it are one gesture apart.

Sites whose coordinates are missing or out of range are counted and reported rather than quietly left off, so a map that is showing you eleven of twelve sites says so.

How do I put a value from my grid on a map?

Load the marker map type beside the charts module and call createChart({ grid, container, type: 'markermap', lon, lat, label, value }), where lon and lat are the columns holding degrees and value is the column whose figure and colour you want on the map. Pass a geometry pack as shapes to draw real boundaries underneath, in that pack’s own projection, with the pan and zoom a country map has. Add selection: true to tie a click on a marker to its row, and labels: false on a dense map to leave the detail to the tooltip.