Differences

This shows you the differences between two versions of the page.

--- wiki:min [2017/05/08 08:04]
admin created
+++ wiki:min [2019/08/29 05:06] (current)
admin
@@ Line 5: / Line 5: @@
 Usage:
-''MIN(variable, options)'' - see below for description.
+''MIN(variable, options, threshold)'' - see below for description.
 ===== Generic Variables (per device type) =====
-''MIN('INC1_AE'), 5''
+''MIN('INC1_AE', 5, 0)''
 Get the minimum value for the selected period
@@ Line 33: / Line 33: @@
 |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 =====

Wattmon EMS