Differences

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

--- wiki:countnz [2018/07/16 06:31]
admin
+++ wiki:countnz [2024/12/24 09:25] (current)
admin
@@ Line 5: / Line 5: @@
 Usage:
-''COUNTNZ(variable, options, val)''
+''COUNTNZ(variable, options, val,[start_hour],[end_hour],[start_min],[end_min])''
 **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
+**start_min** - optional start minute if using a start hour
+**end_min** - optional end minute if using end hour (ie. 18:43 for hour=18 and end_min=43)
 ===== Generic Variables (per device type) =====
@@ Line 49: / Line 57: @@
 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