aggregate_type

Don’t see an aggregate you want? Use SQL to define the aggregate instead, for example: sql: MEDIAN(${orders.price}

Syntax

<measure_name>:
  sql: ${<view_name>.<field_name>}
  aggregate_type: <aggregation_method>

measure_name

object[]

The name of the measure.

Hide measure_name properties

sql

string

The SQL used to create the measure. Specify fields as view_name.field_name.

aggregate_type

string

The aggregation method to apply to the measure. Must be one of:

Sum aggregation

total_revenue:
  sql: ${orders.sales_price}
  aggregate_type: sum

Measure with division

revenue_per_order:
  sql: ${orders.total_revenue} / ${orders.count}

Percentile aggregation

perc_75_age:
  sql: ${users.age}
  aggregate_type: percentile
  percentile: 75

Sum distinct on

sum_distinct_example:
  sql: price
  aggregate_type: sum_distinct_on
  custom_primary_key_sql: ${id}