Run the failure
Use the red CTA to create the analytical problem intentionally.
Practice Lab · 04 · Business Metrics
Metric Contract Debugger
Keep the same numerator but swap the denominator and watch the cancellation story change completely.
DenominatorsMetric contractsBusiness meaning
Case brief
Decide which denominator represents the population that could have produced a cancellation.
01
Your task
Break it. Run the checks. Explain the evidence.
Predict the result
Before validating, decide what you expect row counts or metrics to do.
Run validation
Use the green CTA to reveal the checks that catch the failure.
Explain it
Say what broke in plain business language, not only SQL language.
02
Interactive case
Run this.
RUN THIS CASE ↓
Metric Contract Debugger
Decide which denominator represents the population that could have produced a cancellation.
Ready — run the case. 20 cancellations become either 20.0% or 7.7%.
÷
=
The numerator never changed. The business story changed because the denominator moved to the wrong grain and population.
Debrief unlocked
What should the analyst learn?
- A rate is a population definition disguised as arithmetic.
- Denominator grain must match the business question.
- Metric contracts should make inclusion and exclusion rules explicit.
03
Transfer
Use the same checks at work.
A rate is a population definition disguised as arithmetic.
Denominator grain must match the business question.
Metric contracts should make inclusion and exclusion rules explicit.