Time granularity and time aggregation
In this section, we will introduce the concepts of time granularity and time aggregation. We will show examples of time series with different granularities. Additionally, we will show you how to aggregate time series in KNIME. We will cover these topics in the following subsections:
- Defining time granularity
- Finding the right time granularity
- Aggregating time series data
Defining time granularity
Time granularity refers to the time interval between the observations within a time series. For example, if we record a financial KPI at the end of each year, then the granularity of the time series is yearly. If a glucose monitor reports the glucose level every minute, then the granularity of the time series is by the minute. In general, time granularity can be any time interval: daily, weekly, monthly, quarterly, and more.
To illustrate how time granularity determines the dynamics of a time series, the following screenshot...