Table of Contents

MIN() Function

The MIN() function can be used in a variety of ways to get the minimum value of a variable.

Usage:

MIN(variable, options, threshold) - see below for description.

Generic Variables (per device type)

MIN('INC1_AE', 5, 0)

Get the minimum value for the selected period

Device - Specific Variables

For device specific variables use a . to separate the device name:

MIN('My Device.My Value',1)

Get the minimum value of the variable for the current day.

Option Parameters

The second parameter, [options] is a number and can be any of the following

0 latest value (Default)
1 DAY - Minimum value for current day
2 WEEK - Minimum value for current week
3 MONTH - Minimum value for current month
4 YEAR - Minimum value for current year
5 PERIOD - Minimum value for the selected range
6 SLICE - Minimum value for the slice in the range (i.e. in a graph segment)

The third option parameter allows you to set a threshold value other than 0. This is useful when you are trying to calculate values in expressions such as MAX('var') - MIN('val') on data may be zero at midnight. Leaving the third parameter at 0 would mean the expression would result in the maximum value.

Example

Get the miminum value of a variable for a day:

MIN('delta0_kwh',1)