Historical
- Last UpdatedApr 05, 2020
- 3 minute read
Note: The availability of historical values is dependent upon the "Mobile History" setting (see Configure sync server settings for more information).
|
Function |
Syntax |
Returns |
|---|---|---|
|
@GETLASTVALUE |
@GETLASTVALUE (variable,default) |
Last recorded value for variable1. If none, returns "default" value (most often &NULL). |
|
@HMAX |
@HMAX (variable) |
Highest of historical values of variable |
|
@HMAXNODE |
@HMAXNODE (variable) |
Highest of historical values of variable, limited to Node |
|
@HMAXPOINTS |
@HMAXPOINTS (variable, startpoint, endpoint, minpoints) |
Greatest of historical values over the specified period of the variable’s history2 |
|
@HMAXPOINTSNODE |
@HMAXPOINTSNODE (variable, startpoint, endpoint, minpoints) |
Greatest of historical values over the specified period of the variable’s history2, limited to Node |
|
@HMAXTIME |
@HMAXTIME (variable, starttime, endtime, minpoints) |
Greatest of historical values over the specified period (measured in minutes past) of the variable’s history3 |
|
@HMAXTIMENODE |
@HMAXTIMENODE (variable, starttime, endtime, minpoints) |
Greatest of historical values over the specified period (measured in minutes past) of the variable’s history3, limited to Node |
|
@HMIN |
HMIN (variable) |
Lowest of historical values of variable |
|
@HMINNODE |
HMIN (variable) |
Lowest of historical values of variable, limited to Node |
|
@HMINPOINTS |
@HMINPOINTS (variable, startpoint, endpoint, minpoints) |
Least of historical values over the specified period of the variable’s history2 |
|
@HMINPOINTSNODE |
@HMINPOINTSNODE (variable, startpoint, endpoint, minpoints) |
Least of historical values over the specified period of the variable’s history2, limited to Node |
|
@HMINTIME |
@HMINTIME (variable, starttime, endtime, minpoints) |
Least of historical values over the specified period (measured in minutes past) of the variable’s history3 |
|
@HMINTIMENODE |
@HMINTIMENODE (variable, starttime, endtime, minpoints) |
Least of historical values over the specified period (measured in minutes past) of the variable’s history3, limited to Node |
|
@MEAN |
@MEAN (variable) |
Mean of historical values of variable |
|
@MEANNODE |
@MEANNODE (variable) |
Mean of historical values of variable, limited to Node |
|
@MEANPOINTS |
@MEANPOINTS (variable, startpoint, endpoint, minpoints) |
Mean of historical values over the specified period of the variable’s history2 |
|
@MEANPOINTSNODE |
@MEANPOINTSNODE (variable, startpoint, endpoint, minpoints) |
Mean of historical values over the specified period of the variable’s history2, limited to Node |
|
@MEANTIME |
@MEANTIME (variable, starttime, endtime, minpoints) |
Mean of historical values over the specified period (measured in minutes past) of the variable’s history3 |
|
@MEANTIMENODE |
@MEANTIMENODE (variable, starttime, endtime, minpoints) |
Mean of historical values over the specified period (measured in minutes past) of the variable’s history3, limited to Node |
|
@SDPLASTVALUE |
@SDPLASTVALUE ("Asset," "Asset Type Property," Default Value)4 |
Value of last Shared Data Point for a specified Asset / Asset Type Property pair. |
|
@STDDEV |
@STDDEV (variable) |
Standard deviation of historical values of variable |
|
@STDDEVNODE |
@STDDEVNODE (variable) |
Standard deviation of historical values of variable, limited to Node |
|
@STDDEVPOINTS |
@STDDEVPOINTS (variable, startpoint, endpoint, minpoints) |
Standard deviation of historical values over the specified period of the variable’s history2 |
|
@STDDEVPOINTSNODE |
@STDDEVPOINTSNODE (variable, startpoint, endpoint, minpoints) |
Standard deviation of historical values over the specified period of the variable’s history2, limited to Node |
|
@STDDEVTIME |
@STDDEVTIME (variable, starttime, endtime, minpoints) |
Standard deviation of historical values over the specified period (measured in minutes past) of the variable’s history3 |
|
@STDDEVTIMENODE |
@STDDEVTIMENODE (variable, starttime, endtime, minpoints) |
Standard deviation of historical values over the specified period (measured in minutes past) of the variable’s history3, limited to Node |
1"Last Value" refers to the last recorded value uploaded to the database from a Procedure marked "Complete."
2"Points" represent past readings, where 0 is the most recent value, 1 is the value immediately preceding that, and so on. The number of points between "startpoint" and "endpoint" (inclusive) must meet or exceed the "minpoints" value, else these functions will return NULL.
3The starttime and endtime variables are measured in minutes past, where 0 is current time and 15 is 15 minutes ago.
4The Asset and Asset Type variables provided must be within quotation marks as shown. Provide a Default Value to return in case there is no historical data to fetch.