Ratio Metrics

Ratio metrics let you define a new metric as the division of two existing metrics. They’re useful for KPIs like conversion rate, average price, ARPU, and error rate—any time the business question is naturally expressed as “X per Y”.

A ratio metric is defined as:

Ratio = Numerator Metric ÷ Denominator Metric

Both the numerator and denominator must be valid, existing metrics (simple or advanced). You can optionally apply filters to either side to create scoped ratios (e.g., “CA revenue per total quantity”, “completed orders / all orders”).

Type Params

Numerator (required)

Choose the metric that will appear on top of the division.

Denominator (required)

Choose the metric that will appear on the bottom of the division.

Filters (optional for both numerator and denominator)

Filters can reference any dimension that is reachable via Athenic’s safe join paths. Use filters to define scoped ratios like:

• “Revenue from Enterprise customers / Total revenue”

• “Orders with status = completed / Total orders”

Filter Example: customers.state = 'ca'

Fill Missing Dates and Nulls (optional)

For advanced time-series modeling, you can use these fields to ensure consistent numeric outputs across time:

• Fill Nulls: sets null metric values to a chosen value (commonly 0) so the ratio can be computed more consistently in sparse datasets.

• Fill Missing Dates: joins the metric to a time spine so you get a value for every date in the requested range (even when no source rows exist for some dates).

These options are most helpful when charting ratios over time and you want uninterrupted series.