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

Last updated

Was this helpful?