Need help? Get answers from the docs with Omni's in-app AI! Log in to your Omni instance and open the Omni Agent in the sidebar.
The core declaration of the field definition.
Documentation Index
Fetch the complete documentation index at: https://docs.omni.co/llms.txt
Use this file to discover all available pages before exploring further.
<measure_name>:
sql: ${<view_name>.<field_name>}
Hide measure_name properties
${} syntax, raw SQL functions, or arithmetic operations.Field type is implicit in Omni, and defined based upon the underlying field’s database type. To change the type, CAST the field (for example, sql: ${zip_code}::string).${view.name}) instead of the raw database name. For example, ${orders.id}total_revenue:
sql: ${orders.sales_price}
aggregate_type: sum
revenue_per_order:
sql: ${orders.total_revenue} / ${orders.count}
average_revenue:
sql: AVG(${orders.sales_price})
Was this page helpful?