New Columns
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.1
Input Column Name
The Calculate tool will create a new column. Use this input to name it.
2
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
Adding a Static Exchange Rate
Adding a Static Exchange Rate
I want to add an Exchange Rate column
Addition to Value
Addition to Value
I would like to add 100 to my value column
Multiply Column with Column
Multiply Column with Column
I would like to multiply a column with another column
Order of Operations
Order of Operations
I would like to calculate percentage difference
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 |