This component aggregates values in a selected numeric or string column by timestamps extracted from a column of type Date&Time. The granularity of the timestamps and the aggregation method are defined by the user.
If the selected granularity indicates time, the extracted timestamps will have the same column type as the input column. For other granularities (days, months, etc.), the timestamps will appear in a column of type Local Date.
For Quarter and Week granularity, the first date of the corresponding period (quarter or week) will be returned as a column of Local Date type in the output table.
Note: For Legacy Date&Time column please convert it first to Date&Time using the Legacy Date&Time to Date&Time node.
The available granularities are:
Years
Months
Days
Hours
Minutes
Seconds
The supported Date&Time types are:
Local Date Time
Zoned Date Time
Local Date
Local Time
The available aggregation methods are:
Mean
Mode
Min
Max
Sum
Variance
Count
Required extensions:
KNIME Quick Forms
(https://hub.knime.com/knime/extensions/org.knime.features.js.quickforms/latest)
Options
Output Ports
- A data table containing the extracted timestamps, aggregated values, and a constant value column containing the selected granularity as string. For Quarter and Week granularity, 2 extra columns will be added: Firstly, a "Year" column containing year values, and secondly, a timestamp as the first date of the corresponding period (quarter or week).
Nodes
Table Row to Variable5 ×- String to Date&Time4 ×
- CASE Switch Data (End)3 ×
- CASE Switch Data (Start)3 ×
- Column Filter3 ×
- Show all 24 nodes
Extensions
Links
- No links available