MIN

About the function

Finds the lowest values in time series, numbers, arrays or combinations of these.

There are many variants of this function, some returns a single number as result but most of them returns a time series.

The result series has the same resolution as the input time series. This also applies to cases where there are multiple time series involved and they all have the same resolution. If there are series with different resolutions, the result is a breakpoint series.

Syntax

  • MIN(T)
  • MIN(D) -> returns a number
  • MIN(t) -> returns a number
  • MIN(t,t)
  • MIN(T,t)
  • MIN(t,T)
  • MIN(t,d)
  • MIN(d,t)
  • MIN(d,d) -> returns a number
  • MIN(T,T)

Description

# Type Description
1 t T d D Time series Array of time series Number Array of numbers
2 t d T Time series Number Array of time series

There are similar functions to find highest values, see function MAX

Examples

Example 1: @MIN(T)

Temperature_hour_operative = @MIN(@T('.Temperature_hour'))

@T('.Temperature_hour') returns an array of time series.

Returns the lowest value of all the time series in the array for each time step, e.g.:

Example 2: @MIN(D)

Result = @MIN({1, 5, 8, 2.5, 11})

Result = 1

Result returns the lowest value from the array of numbers.

Example 3: @MIN(t)

Returns the lowest values from the time series for the requested period.

Temperature_hour_operative = @t('.Temperature_hour_raw')/@MIN(@t('.Temperature_hour_raw'))

From the requested period, we can see that the minimum value is -5. Used in calculation the result values are divided on -5.

Temperature_hour_operative = @t('.Temperature_hour_raw')+@MIN(@t('.Temperature_hour_raw'))

From the requested period, we can see that the minimum value is -5. Used in calculation the result values are added by -5.

Example 4: @MIN(t,t)

Temperature_hour_operative = @MIN(@t('.Temperature_hour_raw'),@t('.TempManualCorrection'))

It returns the lowest of the values for each time step in time series 1 and time series 2.

Example 5: @MIN(T,t)

Temperature_hour_operative = @MIN(@T('.Temperature_hour'),@t('.TempManualCorrection'))

@T('.Temperature_hour') is an array of three time series. @t('.TempManualCorrection') is a single time series.

Returns the lowest value of the time series in the array and the single time series for each time step, e.g.:

Example 6: @MIN(t,d)

Result = @MIN(@t('Temperature_hour_raw'),-0.5)

Returns the lowest value of the time series and a selected number for each time step, e.g.:

Example 7: @MIN(d,d)

Result = @MIN(8,2.5)

Result = 2.5

Returns the lowest value of the two numbers.