calculations

A list of calculations defined in the query.

Syntax

query:
  calculations:
    <calculation_name>:
      sql: ${<view_name>.<field_name>} <OMNI SQL TABLE FUNCTION>
      label: <string>

Properties

query

object[]

An object containing the individual parameters that make up a query view’s query definition. See query for more information.

Hide query properties

calculations

object

A list of calculation definitions.

Hide calculations properties

calculation_name

object

The name of the calculation.

Hide calculation_name properties

sql

string

An Omni calculation expression. Specify fields using ${view_name.field_name} syntax.

label

string

Display name for the calculation.

Examples

Calculation that adds 2 to users.age

query:
  fields:
    users.age: age
    users.created_at[year]: created_at_year
    age_calc: age_plus_two
  calculations:
    age_calc:
      sql: ${users.age} OMNI_FX_PLUS 2

Calculation that creates a link

query:
  fields:
    issues.id: id
    issues.number: number
    issue_link: link
  calculations:
    issue_link:
      sql: CONCAT('https://blobsrus.com/issues/', ${issues.number.id})

bind_all_filters

default_group_by

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples