Normalize date granularity
The Normalize Date granularity step allows to extract date information (eg. day, week, year etc.) in a column intended for aggregation.
Step parameters
Date column
(string*): the column on which the date granularity must be appliedDate granularity to apply
column(string)*: Among ( year, quarter number, month, ISO week (monday to monday), week (sunday to sunday) you can choose one or more date granularity to apply.New column
column(string)*: the ending date
Example
Input

Configuration
{
"column": "date",
"granularity": "year",
"new_column": "aggregated_date_column",
}
Output

Last updated
Was this helpful?