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

Icon

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

Output Ports

Icon

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

Links

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.202403181002
On NodePit since: 2023-12-06
Last update: 2024-04-29
KNIME versions: Since 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!