Missing or stale data

TL;DR

A figure is empty, old or wrong. How to tell a filter from a pending step from a real gap.

Diagnose in this order

1. Widen the window. The filtered screens default to roughly the last three months with a row limit. This is the most common cause and costs nothing to rule out.

2. Check the banners. Unhealthy checks, switched-off steps and queue backlogs all appear above every screen.

3. Check the healthchecks at /system/healthchecks. A red check names the step whose output is overdue.

4. Check whether the step is switched off at /system/crons. A paused step still ages, so its check goes red correctly.

5. Check provenance. If the period is before 2022, or between 2022 and 2025 for acquisition data, the answer may be that no source ever supplied it. That is a fact, not a fault. Every object document carries a provenance table.

Repair

Whichever of the above applies: widen the filter, wait for the queue, switch the step on, or record that the history does not exist.

Verify by reading a real row back. Not by re-checking that the batch finished.

The case with no symptom on screen

A stale customer dimension leaves margin correct, because margin does not depend on customer grouping. Nothing on a margin screen indicates it. The only signal is that check going red, and the repair is in reconcile customers.

Evidence

Screen defaults, banner set, check kinds and the margin-independence of the customer dimension from AGENTS.md and config/crons.json. Basis: code-checked at 30f5313.

On this page
About this document