KymiraCertified BI

Failure catalogue · The metric means something else · 22 of 51

OBSERVED FAILURE MODE

The calendar fork.

Fiscal calendars fork. A period can run 4-5-4, 4-4-5, or thirteen equal periods, and period one may not start where the Gregorian month starts. The calendar a file was built on is usually silent inside the file itself. Every comparison that crosses the fork shifts, and the arithmetic stays clean throughout.

What we saw

Meridian Journal Group closes finance on calendar months while its advertising side works on a broadcast calendar. Both exports label the column period, and neither states which calendar produced it. A period over period view assembled from the two compared windows of different lengths and read the boundary shift as movement in the business. Every date parsed. Every total tied. The only evidence of the fork was a period start that did not fall where the other file's did, and no check was reading period boundaries.

Why it passes a glance

Nothing in a fiscal calendar breaks arithmetic. Each period sums correctly, each file reconciles to its own totals, and every date parses without complaint. A comparison across the fork produces a difference that looks exactly like performance, and the reader has no boundary to inspect, because a calendar is a convention rather than a column.

What addresses it

The metric-store skill records the calendar as a durable ruling with an owner and a date rather than a default nobody chose, and the period-freshness skill separates the coverage window from the run stamp so a period label carries the window it actually describes. Principle 10, a metric without its definition is not a number, treats the period definition as part of the definition.

Check your own file in two minutes

  1. Find the first and last date each period covers in the export, not the period name.
  2. Check whether every period covers the same number of days, and where the boundaries fall.
  3. Ask which calendar the source system publishes on, and record the answer beside the source.
  4. Refuse a comparison that crosses two calendars until both sides are restated on one.

What this does not catch

Recording the calendar makes the boundary visible and comparisons deliberate. It does not restate history for you, and where a file carries no dates at all there is nothing to prove the calendar from. A period label the source never asserted stays a claim, not a fact.

Quick answers

What is a 4-5-4 calendar?
A retail convention that groups weeks into periods of four, five, and four weeks so each period ends on the same weekday and comparisons line up year over year. 4-4-5 and thirteen equal periods are the other common shapes.
How do I know which calendar my export uses?
Read the coverage dates rather than the period names. Equal period lengths point to a thirteen period calendar, alternating lengths point to 4-5-4 or 4-4-5, and boundaries landing mid month rule out Gregorian months.
Can I compare a fiscal period to a calendar month?
Only after restating one side on the other calendar and saying so on the page. Comparing them directly produces a difference driven by period length rather than by the business.

Nearby failures

Two honest headlines from one fileThe metric means something elseThe filename that lies about the periodThe file liesTwo churn definitions, 3.4 points apartThe metric means something else

Last updated 2026-09-02 · Dylan, founder · one of 51 observed failure modes, every one seen in a real build or in our own audits, none invented.

Get the free skill → The doctrine All 51 failure modes