How to Calculate Duration Between Two Dates?
There is a case that you want to know the duration between two dates like duration between a date column and a specific date or between two Date columns. So how do you do this in Exploratory?
Create Calculation
For example, if you want to a calculate duration between a specific date (let’s say 2017-03-01
) and date column (let’s say Date Joined
column)
You can calculate duration like below.
This will create a new column called duration
and you can get days out of it from column header menu like below.