PITimeExpDat()
- Last UpdatedNov 21, 2022
- 1 minute read
- PI System
- PI DataLink 2023 SP1
- Visualization
Returns values of a performance equation calculated at specified time stamps.
Syntax
PITimeExpDat(Expression, TimeStamps, RootPath)
Arguments
|
Argument |
Type |
Description |
|---|---|---|
|
Expression |
String |
One or more performance equations that the function computes a value for. See Expressions. To specify multiple expressions, enter a range of cells that contain complete expressions. The function returns values for each. |
|
TimeStamps |
Reference |
A reference to one or more worksheet cells that contain time stamps for which the function returns values. See Time inputs. |
|
RootPath |
String |
The path to the data item. See Data items. |
Returns
Values at the specified time stamps, presented in the same orientation as the time stamp reference. If the time stamp reference is a row, the function presents values in a row. If the time stamp reference is a column, the function presents values in a column. The orientation of the output array must match the orientation of the time stamp reference.
Example
=PITimeExpDat("sqr('sinusoid')",b1:b12,"")
Calculates the square root of the value of the PI point sinusoid retrieved from the default Data Archive server at the times specified in cells B1 through B12.
This function requires a twelve-cell horizontal output array, such as C1:C12 or B14:B25.