Differences

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

--- wiki:countnz [2018/07/16 06:31]
admin
+++ wiki:countnz [2022/07/04 08:39] (current)
admin
@@ Line 1: / Line 1: @@
-====== COUNTNZ() Function ======
+====== COUNTNZ() Function (Count Non-Zero) ======
-The COUNTNZ() function can be used to get the last time a variable was changed - it returns a human readable time.
+The COUNTNZ() function can be used to get the number of minutes a value is greater than a threshold value
 Usage:
-''COUNTNZ(variable, options, val)''
+''COUNTNZ(variable, options, val,[start_hour],[end_hour])''
 **variable** - the variable name to check
@@ Line 12: / Line 12: @@
 **val** - optional - the threshold value to be greater than (0 is the default)
+**start_hour** - option for 'diff in range (option 5) when period is 1 day - start hour (0-23)
+**end_hour** - option for 'diff in range (option 5) when period is 1 day - end hour (0-23) - set start and end to 0 to ignore this
 ===== Generic Variables (per device type) =====
@@ Line 49: / Line 54: @@
 Possible return values: 0 - 100
+===== Example2 =====
+Get the minutes the DG was running for between 6am and 6 pm (18)
+''(COUNTNZ('DG1_AC_Active_Power',5,0,6,18))''

Wattmon EMS