Calculate
Create new columns with calculations
The Calculate tool is one of the most used tool. It helps you create new columns using math. The Calculate tool can be used with all basic math operations like addition, subtraction, division, multiplication. You can use it with the columns in your dataset or to create/add static calculations/numbers.
You can only reference numeric columns (integers/whole number or float/decimal columns) in the Calculate tool
Configuration
The Calculate tool has of two required input.
Input Column Name
The Calculate tool will create a new column. Use this input to name it.
Input Calculation
Simply type your calculation. Use + for addition, - for subtraction, * for multiplication and / for division. Remember to use parentheses to create order of operations.
Start typing a column name to reference it - for example Amount
When To Use
The possibilities are endless with the Calculate tool. Use it whenever you need to add a custom calculation.
Examples
Advanced Syntax
Please reach out to us if you need additional advanced syntaxes
| Syntax | Description |
|---|---|
| [column].var() | Variance |
| [column].median() | Median |
| [column].sqrt() | Square Root |
| [column].log(base=someNumber) | Logarithm to a given base |
| [column].exp() | Exponential |
| [column].hash() | Hash the value |