Choosing Axiom: does a renamed event field change what you count?

Compare query-time normalization with your current process on five invented events, with no live logs.

Source: axiom.co
September 7, 2026
2 min

When old and new systems give one status field different names, you may need an auditable counting rule rather than another full migration. This Axiom is the axiom.co event platform, not a similarly named browser tool. Its official APL docs describe virtual fields made at query time, and the 2024 Flow announcement describes queryable stored events and APL. Renaming at query time is useful but does not prove the fields mean the same thing.

Set the expected answer for five fictional events

Use invented paper-card indexing events with no accounts, real logs or external systems. Two old-format items say archived and not archived. Three new-format items say archived, archived and status missing. Once a person confirms both definitions agree, expect 3 archived, 1 not archived and 1 unknown, total 5. Treat unknown as not archived and that count rises to 2; ignore it and the total drops to 4. The graphic is an expectation, not product output.

Article img
Original diagram: five records from two formats yield 3 archived, 1 not archived, 1 unknown.

Synthetic acceptance target, not Axiom output. 3+1+1=5; missing status neither means failure nor disappears from the total.

Test more than the combined field

Put those five items beside the current sheet and proposed query. Reconcile version markers, unified results and unknowns. Add a sixth, separate case with both fields and conflicting values to confirm it goes to review rather than arbitrary selection. Keep original values and the conversion rule traceable. If dashboards lose unknowns or conflicts, fix the definition before buying. This article runs no queries, connects no production systems and reads or exports no real logs.

If you have only one stable format, retain the current sheet or query. With both formats in long-term use, compare time spent maintaining definitions, preserving data, reviewing access and export, and rewriting old data, plus query costs. Extend a trial only if totals and unknowns survive, a review owner is named, and a written quote covers processing, search and retention.

Content note:This article is based on publicly available information and is intended as a reference for evaluating tools. Features, pricing, and related policies may change at any time; please refer to the latest official information.

Original source:axiom.co