Skip to content
Documentation

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.

Interval transformation either condenses many short intervals, such as four 15-minute values, into one longer interval, or spreads one longer interval value over many short intervals, using a transformation method

flask 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.

Different use cases require different methods of interval transformation to provide feasible results. The following interval transformation methods are currently available:

Direction
Method

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).

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.

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.

flask 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

flask 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

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.

flask 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

flask 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.

flask 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

flask 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.

flask 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

flask 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

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.

flask 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

flask 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

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.

flask 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

flask 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

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.

flask 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

flask 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

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.

flask 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

flask 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

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.

flask 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

flask 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
© 2026 Volue.Version v0.6.38017 November 2026