Calculations

Below is a list of valid calculations which can be included in a formula.

The arguments to the aggregation are column names, e.g. amount, or formulas themselves, e.g. risk_factor in ["low_risk"].

Note

Calculations can also be passed into aggregations.

Arithmetic

radius * 2
length ^ 3
female_students + male_students
gross_revenue - liabilities
net_revenue / 12
total_students / total_teachers

(gross_revenue - liabilities) / 12

female_students > male_students
average_age == 18

age > 17 age < 22
not (month == 7 or month == 12)

risk_factor in ["low_risk", "medium_risk"]

For the time being all date arithmetic is performed in seconds.

date("09-04-2012") - submit_date > 21078000

To calculate dynamic time periods, such as age, you can use the today function:

today() - submit_date > 21078000

Analogous to the case or switch statement in other programming languages.

case student_teacher_ratio > 0.6: "good", student_teacher_ratio > 0.3: "moderate", default: "poor"

Transformations are functions that convert a scalar into another scalar based on a vector.

percentile(amount)