General Principles
Add Missing Dates
Add text column
Add Total Rows
Aggregate
Append
Compare Text Columns
Argmax
Argmin
Concatenate columns
Convert
Convert date to text
Convert text to date
Cumulated sum
Cutom step
Delete column(s)
Duplicate
Duration
Evolution
Extract date property
Extract substring
Fill null
Filter
Formula
Get unique groups/values
Hierarchical rollup
ifthenelse
Join
Keep column(s)
Moving Average
Percentage
Pivot
Rank
Rename
Replace
Sort
Split column
Column's Statistics
To lowercase
To uppercase
Top N rows
Unpivot
Waterfall
Formula
You can use this step to create a column as a formula based on other columns. A column can be referenced by its name without quotes unless they include whitespaces, in such a case you need to use brackets ‘[]’ (e.g. [myColumn]).
Any characters string escaped with quotes (simple or double) will be considered as a string.
This step is supported by the following backends:
- Mongo 4.2
- Mongo 4.0
- Mongo 3.6
- Pandas (python)
Where to find this step?
- Widget
Add
andCompute
- Search bar
Options reference
-
New column
: the name of the new column to be created with the formula result. -
Formula
: the formula, which can be an algebraic formula composed of numbers, maths operators and columns; it can also be a text (escaped by quotes) to uniformly fill the column with that text.
Example 1: Basic usage
This configuration results in:
Example 2: Columnn names with whitespaces
This configuration results in:
- Previous
- Next