ContinuousSmall_Sampled(Expr ,ValueIndex ,StartTime [,EndTime] [,SampleMethod] [,SampleInterval])<\/strong><\/p>\n Returns the nth smallest value at which an expression is held over a range of time.<\/p>\n Expr:\u00a0<\/b>The expression whose values should be processed to find nth smallest value. ValueIndex:\u00a0<\/b>The zero-based ordinal (n) of the value to return, i.e. use zero to return the smallest value, use 1 to return the second smallest value, etc.\u00a0 If the ordinal is greater than the number of values then an error will be returned. StartTime:\u00a0<\/b>The start time over which to produce the nth smallest value. Note: You can use the Time() function to use a valid DateTime argument. EndTime:\u00a0<\/b>The end time over which to produce the nth smallest value. Note: If not specified, it assumes the current time. You can use the Time() function to use a valid DateTime argument. SampleMethod:\u00a0<\/b>This optional parameter can be used to override the sample method which will be used for evaluating the expression (1st parameter). SampleInterval:\u00a0<\/b>This optional parameter can be used to override the sample interval which will be used for evaluating the expression (1st parameter). Expression: ContinuousSmall_Sampled(Expr, 0, Time() - 60, Time())<\/span> Expression: ContinuousSmall_Sampled(Expr, 1, Time() - 60)<\/span> Expression: ContinuousSmall_Sampled(Expr, 2, Midnight(Time()))<\/span> Expression: ContinuousSmall_Sampled({tag, sampleMethod = \"Raw\"}, 0, Time() \u2013 60)<\/span> Expression: ContinuousSmall_Sampled(Sampling(Expr, \"raw\"), 1, Time() - 60)<\/span> Expression: ContinuousSmall_Sampled(Expr, 2, Time() - 7200, Time(), 'LastKnownValue', 3600)<\/span> ContinuousSmall_Sampled() can be used to find the nth smallest value in a time range.<\/p>\nReturns<\/h2>\n
Inputs<\/h2>\n
\nBehaviour: Required
\nDimensions: Expression
\nValid data types: Expression<\/p>\n
\nBehaviour: Required
\nDimensions: SingleValue
\nValid data types: Integer<\/p>\n
\nBehaviour: Required
\nDimensions: Collection, SingleValue
\nValid data types: DateTime, Decimal, Integer, String<\/p>\n
\nBehaviour: Optional
\nDimensions: Collection, SingleValue
\nValid data types: DateTime, Decimal, Integer, String<\/p>\n
\nBehaviour: Optional
\nDimensions: SingleValue
\nValid data types: String<\/p>\n
\nBehaviour: Optional
\nDimensions: SingleValue
\nValid data types: DateTime, Decimal, Integer, String<\/p>\nExamples<\/h2>\n
\nResult: Smallest value over the last minute (60 seconds).<\/p>\n
\nResult: Second smallest value over the last minute (60 seconds).<\/p>\n
\nResult: Third smallest value since midnight (the start of the day).<\/p>\n
\nResult: Smallest of the raw values over the last minute.<\/p>\n
\nResult: Second smallest of the raw values over the last minute.<\/p>\n
\nResult: Evaluates the expression using the last known value sample method and 1-hour sample interval and returns its third smallest value over the last 2 hours.<\/p>\nRelease History<\/h2>\n
\n
\n