What is a metrics layer?
A metrics layer is a central place where key business metrics, like revenue, active users or churn, are defined once in code so every tool and report computes them the same way. It prevents conflicting numbers by making one governed definition the single source of truth for each metric.
The classic analytics problem is that 'revenue' is calculated three different ways in three different tools. A metrics layer (sometimes part of a semantic layer) fixes this by defining each metric once, its formula, filters and grain, so any query that asks for it gets the same answer.
A metrics layer provides:
- Consistency one definition, reused everywhere.
- Governance changes made in one controlled place.
- Reusability metrics composed across dashboards and questions.
- Trust numbers reconcile because the logic is shared.
iDBQuery embraces this idea through its semantic layer. You can encode the meaning of your data and the definitions of your key metrics once, and iDBQuery applies them consistently whenever someone asks a related question in plain language. Because it then writes the SQL and cites every figure back to source rows, you get both consistency and transparency, the same governed metric definition, plus a click-through audit of exactly which records produced the number. Teams get self-serve answers without the usual risk of everyone inventing their own version of a metric.
Updated 2026-06-22