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
Custom step
Delete column(s)
Geographically dissolve data
Duplicate
Duration
Evolution
Extract date information
Extract substring
Fill null
Filter
Formula
Geographical hierarchy
Get unique groups/values
Hierarchical rollup
ifthenelse
Join
Keep column(s)
Moving Average
Percentage
Pivot
Rank
Rename
Replace
Geographical simplification
Sort
Split column
Column's Statistics
To lowercase
To uppercase
Top N rows
Unpivot
Waterfall
Compute Duration
Compute the duration (in days, hours, minutes or seconds) between 2 dates in a new column.
This step is supported by the following backends:
- Mongo 5.0
- Mongo 4.2
- Mongo 4.0
- Mongo 3.6
Where to find this step?
- Widget
Dates
- Search bar
Options reference
-
New column name
: the new column to be created for the computation result -
Start date column
: the starting date -
End date column
: the ending date -
Duration in
: the duration units (days, hours, minutes or seconds)
Example 1: duration in days
This configuration results in:
Example 2: duration in minutes
This configuration results in:
- Previous
- Next