Differences

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

--- wiki:value [2017/05/08 05:06]
admin
+++ wiki:value [2020/07/23 04:13] (current)
admin
@@ Line 5: / Line 5: @@
 Usage:
-''VALUE(variable, options)'' - see below for description.
+''VALUE(variable, options, [max])'' - see below for description.
 ===== Generic Variables (per device type) =====
@@ Line 24: / Line 24: @@
 You can also use VALUE('user_field1') to access the user defined field.  These values are entered when you edit a device and can contain device specific static information.
+The list of special device-specific variables available are as follows:
+|**Variable** | **Description** |
+|device_key | MAC ADDRESS |
+|remote_ip | IP Address of wattmon |
+|last_access | last update timestamp |
+|tz_offset | GMT Offset in seconds |
+|geo_lat | Latitude of device |
+|geo_lon | Longitude of device |
+|user_field1 | User Defined field 1 |
 ===== Option Parameters =====
@@ Line 33: / Line 44: @@
 |7 | latest value for selected period |
-Example:
-''VALUE('INC1_AE',5)''
+The third optional parameter [max] allows you to specify a maximum value for the data point, and if the value is greater than this the result will be 0.  This is to help in cases where incorrect data may come in from sensors are other devices.
+===== Example =====
+Get the latest value of two watt hour counters and scaled them to kWh
+''(VALUE('delta0_wh',7)+VALUE('delta1_wh',7)) / 1000''

Wattmon EMS