Interval Transformation
When the interval of data is different from the interval of the corresponding time series it becomes necessary to condense or spread the data as needed in order to obtain feasible results.
Typical interval transformations
Section titled “ Typical interval transformations”- A time series stores daily consumption records. The data is read out for an entire year as one value.
- A sensor provides hourly values. The data is stored on a time series with a 15 minute interval.
In the context of PowerTSM time series as well as in this documentation, both operations in the above examples are referred to as interval transformation.
Interval Transformation Methods
Section titled “Interval Transformation Methods”Different use cases require different methods of interval transformation to provide feasible results. The following interval transformation methods are currently available:
Order of Interval Transformation Methods
Section titled “Order of Interval Transformation Methods”There are multiple ways to apply an interval transformation method to a data operation and an inherent order controls which method will be applied in case more than one interval transformation method would be applicable. The possible configuration options are listed here in the order they will be overruled (e.g. an interval transformation method configured in the master data of a time series will overrule the interval transformation method specified for the unit assigned to this time series).
Time Series
Section titled “Time Series”Each time series may have its own interval transformation method configured as part of the time series master data. See What Is a Time Series? for more information on time series master data.
Certain units are preconfigured in the PowerTSM database with an interval transformation method. These entries can be changed, deleted, or extended (see Units and Conversions). The aggregation method for each unit is stored in the AGGREGATION column of the FWS_UNITCONVERSION table. This unit-level method only applies when the time series itself has no transformation method configured.
Default
Section titled “Default”If both the time series and the unit have no aggregation method configured, then Average is used by default.
Values are summed up when condensing multiple values from short intervals over a longer time period and divided proportionally when spreading a value over multiple intervals.
Sum: higher interval → lower interval
Section titled “ Sum: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | 10 | 00:00 - 01:00 | (10+20+30+40) = 100 |
| 00:15 - 00:30 | 20 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | 40 |
Sum: lower interval → higher interval
Section titled “ Sum: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100/4 = 25 |
| 00:15 - 00:30 | 100/4 = 25 | ||
| 00:30 - 00:45 | 100/4 = 25 | ||
| 00:45 - 01:00 | 100/4 = 25 |
Average
Section titled “Average”Values are averaged out when condensing multiple values from short intervals over a longer time period and repeated when spreading a value over multiple intervals.
Average: higher interval → lower interval
Section titled “ Average: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | 10 | 00:00 - 01:00 | (10/4+ 20/4+ 30/4+ 40/4) = 100/4 = 25 |
| 00:15 - 00:30 | 20 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | 40 |
Average: lower interval → higher interval
Section titled “ Average: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100 |
| 00:15 - 00:30 | 100 | ||
| 00:30 - 00:45 | 100 | ||
| 00:45 - 01:00 | 100 |
Provides the lowest value in the selected time period when condensing multiple values and behaves like Average when spreading a value over multiple intervals.
Min: higher interval → lower interval
Section titled “ Min: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | 10 | 00:00 - 01:00 | 10 |
| 00:15 - 00:30 | 20 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | 40 |
Min: lower interval → higher interval
Section titled “ Min: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100 |
| 00:15 - 00:30 | 100 | ||
| 00:30 - 00:45 | 100 | ||
| 00:45 - 01:00 | 100 |
Provides the highest value in the selected time period when condensing multiple values and behaves like Average when spreading a value over multiple intervals.
Max: higher interval → lower interval
Section titled “ Max: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | 10 | 00:00 - 01:00 | 40 |
| 00:15 - 00:30 | 20 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | 40 |
Max: lower interval → higher interval
Section titled “ Max: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100 |
| 00:15 - 00:30 | 100 | ||
| 00:30 - 00:45 | 100 | ||
| 00:45 - 01:00 | 100 |
MostFrequently
Section titled “MostFrequently”Provides the most frequently used value in the selected time period when condensing multiple values. In case multiple values occur with the same frequency, the chronologically last of these values will be returned. When spreading a value over multiple intervals MostFrequently behaves like Average.
MostFrequently: higher interval → lower interval
Section titled “ MostFrequently: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | 10 | 00:00 - 01:00 | 20 |
| 00:15 - 00:30 | 10 | ||
| 00:30 - 00:45 | 20 | ||
| 00:45 - 01:00 | 20 |
MostFrequently: lower interval → higher interval
Section titled “ MostFrequently: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 10 | 00:00 - 00:15 | 10 |
| 00:15 - 00:30 | 10 | ||
| 00:30 - 00:45 | 10 | ||
| 00:45 - 01:00 | 10 |
FirstValue
Section titled “FirstValue”Provides the first value in the selected time period when condensing multiple values. Values with the flag “Missing” will be ignored by this interval transformation method. When spreading a value over multiple intervals FirstValue behaves like Average.
FirstValue: higher interval → lower interval
Section titled “ FirstValue: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | 20 | 00:00 - 01:00 | 20 |
| 00:15 - 00:30 | 10 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | 40 |
FirstValue: lower interval → higher interval
Section titled “ FirstValue: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100 |
| 00:15 - 00:30 | 100 | ||
| 00:30 - 00:45 | 100 | ||
| 00:45 - 01:00 | 100 |
LastValue
Section titled “LastValue”Provides the last value in the selected time period when condensing multiple values. Values with the flag “Missing” will be ignored by this interval transformation method. When spreading a value over multiple intervals LastValue behaves like Average.
LastValue: higher interval → lower interval
Section titled “ LastValue: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | 20 | 00:00 - 01:00 | 40 |
| 00:15 - 00:30 | 10 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | 40 |
LastValue: lower interval → higher interval
Section titled “ LastValue: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100 |
| 00:15 - 00:30 | 100 | ||
| 00:30 - 00:45 | 100 | ||
| 00:45 - 01:00 | 100 |
AbsMin
Section titled “AbsMin”Similar to the interval transformation method Min this method provides the lowest absolute value in the selected time period when condensing multiple values, ignoring positive/negative signs and behaves like Average when spreading a value over multiple intervals.
AbsMin: higher interval → lower interval
Section titled “ AbsMin: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | -20 | 00:00 - 01:00 | 10 |
| 00:15 - 00:30 | 10 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | -40 |
AbsMin: lower interval → higher interval
Section titled “ AbsMin: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100 |
| 00:15 - 00:30 | 100 | ||
| 00:30 - 00:45 | 100 | ||
| 00:45 - 01:00 | 100 |
AbsMax
Section titled “AbsMax”Similar to the interval transformation method Max this method provides the highest absolute value in the selected time period when condensing multiple values, ignoring positive/negative signs and behaves like Average when spreading a value over multiple intervals.
AbsMax: higher interval → lower interval
Section titled “ AbsMax: higher interval → lower interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 00:15 | -20 | 00:00 - 01:00 | 40 |
| 00:15 - 00:30 | 10 | ||
| 00:30 - 00:45 | 30 | ||
| 00:45 - 01:00 | -40 |
AbsMax: lower interval → higher interval
Section titled “ AbsMax: lower interval → higher interval”| Source Interval | Value | Target Interval | Aggregated Value |
|---|---|---|---|
| 00:00 - 01:00 | 100 | 00:00 - 00:15 | 100 |
| 00:15 - 00:30 | 100 | ||
| 00:30 - 00:45 | 100 | ||
| 00:45 - 01:00 | 100 |