An input dataset has to contain at least:
- a column of type Datetime
- further columns (on which the aggregation function is applied)
The output data contains the aggregated values of the selected columns for a specified aggregation interval.
In the following example, we use a sample of a transaction dataset. The given workflow calculates the sum of all transactions in a given time interval.
The interval representation in the result table contains the starting instant. according to both the input and the output datasets, the week containing the date 2020-03-01 starts on Monday 2020-02-24.