Date&Time Aggregator (Labs)

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.

Input ports

1. Type: Table
   Input Data

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

Output ports

1. Type: Table
   Aggregated Output

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