Time Rounder

Rounds time columns to a specified granularity. You can adjust time values using user-defined rounding strategies and precision and either replace or append the rounded values to the input table.
Commonly used to round times to the nearest minute, hour, or other time units for aggregation or reporting.

Options

Date&time columns

The date&time columns whose values are shifted.

Round to

The rounding strategy to apply, either round to the first, last or nearest value of the chosen rounding precision.

• First point in time: Rounds to the first point in time of the selected duration. E.g., rounding 18:45.215 to one hour yields 18:00.
• Last point in time: Rounds to the last point in time of the selected duration. E.g., rounding 18:45.215 to one hour yields 19:00.
• Nearest point in time: Rounds to the nearest point in time of the selected duration. E.g., Last/First is chosen depending on which one is closer to the to be rounded time

Rounding precision

The rounding precision. The date will be rounded to the first or last value of the chosen precision. Represented as a duration, i.e., PT1H for one hour.

Output columns

Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.

• Replace: Replaces the selected columns by the new columns.
• Append with suffix: Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.

Output column suffix

The suffix to append to the column names of the new columns.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers