TODAY’S DATA LENS

Missing is not zero.

Square Today’s Data Lens card titled ‘Missing is not zero.’ Two side-by-side line charts show the same illustrative Monday-to-Friday series with Wednesday missing. The left incorrectly treats the missing Wednesday value as zero and creates a dramatic plunge; the right leaves a visible gap labelled ‘NO DATA’. The card explains that unknown values should not be silently plotted as zero or connected across as if observed.

A little further

Missing values can look harmless in a table. In a chart, the treatment can change the story. Replacing missing with zero invents an event that may never have happened; joining the points either side assumes a path you do not know.

The right choice depends on why the value is missing. A sensor outage, suppressed count and genuine zero are different states.

A useful check: could a reader tell the difference between “nothing happened” and “we don’t know what happened”?

Unknown is a data state too.