Info360 contains a library of built-in functions that can be used for plotting, searching, and tracking data. Functions offer a variety of analysis tools for visualizing and monitoring data.
All of the functions can be accessed from the Analytical Functions window. All functions are organized into four tabs on the left: General, Statistics, Moving Average, System, and Sensor.
In the Analytical Functions window, start typing the function name in the Search box to get an immediate list of all the functions containing the typed content. This can greatly speed up finding favorite functions.
Using Analytical Functions Interface
Each function can be run on the current data set by simply selecting the function in the main window, adjusting any customized fields on the right pane, and clicking OK.
Alternately, a custom expression can be entered in the bottom pane to utilize any combination of functions from any sensor data.
For information on setting up custom equations and syntax, please refer to Advanced Use of Analytical Functions.
The following list contains all of the Info360 functions. Select any function below for more information and syntax.
- HighestTime and LowestTime
- Correlation - Pearson Product Correlation
- Process Capability and Process Performance Indices
- RMSE - Root Mean Square Error
- StdDev - Standard Deviation
- StdErr - Standard Error
- EMA - Exponential Moving Average
- MA - Moving Average
- SQRT - Square Root
- WMA - Weighted Moving Average
- Abs - Absolute Value
- Current Time Functions
- Date and Time Functions
- IIF - If statement
Advanced Use of Analytical Functions
Input Time Series Data
Each function does analysis on a time series of data.
In many cases this input is optional, and the current sensor will be used as a default.
For example, if there is chart for 'SCADATagA.Flow Rate' then both of these expression will result the same trend:
Close() + Low()
Close('SCADATagA.Flow Rate') + Low('SCADATagA.Flow Rate')
Some functions require the input to be a Sensor ID, while other functions use other functions as input.
Regardless of the selected time interval used (hourly, daily, etc.), most of these functions require raw sensor data in between sampled time intervals.
Date and Time Functions, etc.
Sensor ID or Function
These functions reference both the time series data and data associated with the sensor. These functions perform better directly on the sensor, however some functions can be passed as input as well.
Most functions use other functions as an input.
To specify a certain sensor for input data in these functions, use one of the functions that takes Sensor ID as input (e.g. Close(), Sensor(), High(), etc.).
The optional time series data input for these functions is typically not mentioned in the Analytical Functions window, but it can always be assigned using the first input in the function. Info360 will check if the first input argument is time series data, if it is then that data will be applied as the input data. If it is not time varying, then it applies the current primary time series data to the function.
Change(4) - Outputs the difference between the current value and the value reported four periods ago for the current sensor.
Change(Sensor('j50.Pressure'),4) - Outputs the difference between the current value and the value reported four periods ago for sensor "J50.Pressure".
Change('J50.Pressure',4) - Error. This function requires a set of time series data (i.e. the output from another function), not a string.
Combining Functions with Mathematical Operators
Function expressions can be combined with various mathematical operators.
Info360 recognizes the following standard math operators: [ + - * / ]
Example: (High() * 2) + (Low() / 4)
These operations can also be fed as input to other functions (that recognize functions as input).
Example: ROC( Open() - Open(), 4)
Info360 also recognizes standard logical comparison operators [=, <, <=, >, >=, <>, !=] which result in true/false statements.
The output from comparisons is in the format of 1 for true and 0 for false.
(PercentFull( High() ) - PercentFull( Low() )) < 15
Outputs a value of 1 on any day that the range in percent full of a tank is less than 15%
Close()*0 <> 0
Outputs a value of 1 any time the sensor is missing a data point.
This expression can be used in IIF statements and Searches.
Abs(Close() - Open())
Outputs the absolute value of the change between the open and close values. This indicates how much tank levels are fluctuating during each sampled interval.