RANGE_MIN

Compute the minimum value for a given property within a time window defined by a start date and an end date.

Usage

RANGE_MIN(eventListName, propertyName, startDate, endDate)

Parameters

eventListName	String	The name of the event list containing the events to use.
propertyName	String	The name of the property to get a minimum for. It needs to be a number property.
startDate	DateTimeString	The date we should start computing the minimum from.
endDate	DateTimeString	The date and time we should stop computing the minimum to.

Returns

Number

Examples

RANGE_MIN(‘MyColl’, ‘Temp’, ‘2021-03-04’, ‘2021-03-15’)	Minimum of Temp for events in MyColl fired between 3/4/21 and 3/15/21.
RANGE_MIN(‘MyColl’, ‘Temp’, ‘2021-03-04’, GET_CURRENT_TIME())	Minimum of Temp values for events in MyColl fired between 3/4/21 and now.

Remarks

If the provided collection name does not exist, or if no events were fired in the provided time window, the function will return 0.