The field guide

Reports & decisions / GUIDE + WORKSHEET

Define a metric once so everyone counts it the same way

Create a reusable metric definition with grain, exclusions, cutoff, source, and boundary examples that expose ambiguity.

By Smithers2 min readFor teams with conflicting dashboard definitions

THE STARTING POINT

A metric definition should explain the business question, counted unit, inclusion rules, source, period, and accountable owner. Add examples at the boundaries. A formula alone is insufficient when people disagree about what counts as active, completed, won, or overdue.

01

Name the unit being counted

Clarify whether the metric counts people, accounts, orders, order lines, visits, or projects. The same customer may appear many times in a transaction table. Specify how duplicates and linked records should be treated, and whether a count is distinct. This prevents a seemingly harmless join or export from changing the meaning of the number.

02

Write inclusion and timing rules

Define each relevant state and the event date used to place a record in a period. Explain whether late corrections update past reports or appear in the current period. Include time zone and currency assumptions when applicable. Use language that both the business owner and the person implementing the report can understand without private interpretation.

03

Use boundary examples as checks

Choose a normal included record, a normal excluded record, and an ambiguous case. Agree on their expected treatment and keep them beside the definition. When the business changes a process, review whether the examples still make sense. Version substantive changes so readers know why a trend changed and can avoid comparing incompatible periods.

WORKED EXAMPLE / ILLUSTRATIVE

A fictional active-client definition

A service team defines active clients as distinct accounts with at least one open delivery project at the cutoff. This is one operational definition, not a universal standard. It excludes a former client who only has an unpaid historical invoice.

AccountStateCount?
ATwo open projectsOne active client
BAll delivery closed, old invoice unpaidNo
CProposal only, no projectNo

MAKE IT USEFUL

Metric definition card

Keep this with the report and its implementation.

Your notes stay in this page and are not sent to Smithers. Download or copy them before leaving; refreshing clears them.

Before you put it to work

  • Clarify the counted unit.
  • Include ambiguous examples.
  • Document late corrections.
  • Version meaningful definition changes.

Renaming two different calculations to the same label does not align them. Reconcile their underlying rules first.

IF THIS LOOKS FAMILIAR

Your tools. Your particular mess.

The worksheet is yours to use. If the difficult part is making it work with the systems you already have, that's the kind of thing we help with.

Get consistent reporting definitions