Metric files
A short YAML file per metric that says what it counts, who owns it, which dimensions it can be sliced by, and how it is tested.
Define each metric once, with an owner, and point every report at that definition.
Download the PDFA short PDF to share with your team. It covers what is in the package, how it works, and a worked example.
Your download has started.
We also emailed the link to . It works for 7 days.
Download didn't start? Get the PDF
Want to try it on your own data? Talk to us.
Each dashboard rewrites the same metric in its own SQL. Teams bring different numbers to the same meeting, the meeting turns into a reconciliation, and nobody can say which figure is right or who owns it.
A short YAML file per metric that says what it counts, who owns it, which dimensions it can be sliced by, and how it is tested.
Compiles simple, ratio, and derived metrics to SQLite and ANSI SQL. Exports MetricFlow YAML for the dbt Semantic Layer and DAX measures for Power BI.
Someone other than the owner approves each metric. The approval is recorded against a fingerprint of the definition, and a catalog lists the certified metrics for business users.
Every metric is checked against the system finance or operations already relies on.
Say where the data comes from, which column holds the date, and which dimensions and measures exist.
Simple, ratio, or derived metrics built on those measures. Ratios are computed after aggregation.
A metric can only be sliced by its allowed dimensions, and never below the grain it was defined at.
Not null, range, dimensions that sum to the total, and a reconciliation against a source figure.
Granted only when every test passes, every dependency is certified, and the certifier is someone other than the owner.
Any edit changes the fingerprint and flags the metric until it is certified again.
Gross sales, refunds, net sales, and order counts are each defined once and tested against the ledger.
Net sales stays uncertified until someone explains the gap, so it cannot reach a board pack before it can be defended.
Ask about the Metrics Layer Starter
Dex answers from our own pages and links to where it found the answer.
Tell us. We will show you what its definition file and reconciliation test would look like.