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 applied

• Date 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

The following granularities are supported:

• year: calendar date corresponding to the first day (1st of January) of the year

• quarter: calendar date corresponding to the first day of the quarter

• month: calendar date corresponding to the first day of the month

• week: calendar date corresponding to the first day of the week (sunday)

• isoWeek: calendar date corresponding to the first day of the week (monday)

• day: calendar date corresponding to the first hour of the day

Example

Input

Date - Normalize date granularity input

Configuration

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

Output

Date - Normalize date granularity output