This node is currently not available in KNIME v5.4 — instead we’re showing this page for KNIME v5.2. You can use the version menu in the title bar to permanently switch your preferred version. This will also show the link to the update site.

Date&Time Aggregator

The aggregation granularity node works a lot like group by node except to define your grouping, select a timestamp column and a level of granularity to define your groups. Then numeric columns can be aggregated to: mode, min, max, sum, var, count, or mean. mode will return the first mode in the event of a tie.

Options

Aggregation Granularity Parameters

Timestamp Column

The timestamp column to perform selected time granularity.

Aggregation Column

The numeric column to apply selected aggregation method.

Time Granularity

Options to select expected granularity in output timestamp column.

Available options:

Year: Aggregate Granularity on Year
Quarter: Aggregate geanularity on quarters
Month: Aggregate granularity based on months.
Week: Aggregate granularity based on weeks.
Day: Aggregate granularity based on days.
Hour: Aggregate based on hours
Minute: Aggregate based on minutes, preferably from seconds
Seconds: Aggregate granularity based on seconds.

Aggregation Method

Options to select method of aggregation to be applied on the selected numeric column.

Available options:

Mode: Pick the most commonly occuring value
Minimum: Aggregate minimum value in the interval
Maximum: Aggregate maximum value in the given interval.
Sum: Sum value in the selected granularity range.
Variance: Calculate variance in the given interval
Count: Count number of instance s in the aggregation interval
Mean: Calculate mean on the selected interval

Input Ports

: Table containing the timestamp column and the numeric column to apply the selected aggregation method

Output Ports

: Table output containing the timestamp based on selected granularity and the aggregated numerical column.

Popular Predecessors

No recommendations found

Popular Successors

No recommendations found

Views

This node has no views

Workflows

No workflows found

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension Time Series Extension from the below update site following our NodePit Product and Node Installation Guide:

v5.2

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 1.0.0.202409270142

On NodePit since: 2023-12-06

Last update: 2024-12-25

KNIME versions: From v5.2 to v5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!