Skip to main content

Syntax

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

Properties

measure_name
object[]
The name of the measure.

Examples

Sum of a field
total_revenue:
  sql: ${orders.sales_price}
  aggregate_type: sum
Measure with division
revenue_per_order:
  sql: ${orders.total_revenue} / ${orders.count}
Custom SQL function
average_revenue:
  sql: AVG(${orders.sales_price})