PIExpDat()
- Last UpdatedNov 21, 2022
- 1 minute read
- PI System
- PI DataLink 2023 SP1
- Visualization
Returns evenly-spaced, computed values of a performance equation over a specified time period.
Syntax
PIExpDat(Expression, STime, ETime, Interval, OutCode, 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. |
|
STime |
String |
The start of the time period for which the function calculates a value. See Time inputs. |
|
ETime |
String |
The end of the time period for which the function calculates a value. See Time inputs. |
|
Interval |
String |
The interval between returned values. Enter a value and time unit that specifies the length of the interval. For example, enter 15m (15 minutes) to return a value for every 15-minute interval during the time period. See Learn about time-interval specifications. |
|
OutCode |
Integer |
An output code that determines what appended data the function returns and how the function orients output. See Output codes for information on how to compute the code. This function supports bits 1 and 2. |
|
RootPath |
String |
The path to the data item. See Data items. |
Example
=PIExpDat("sqr('sinusoid')","y","t","1h",1,"thevax")
Calculates the square root of the value of the PI point sinusoid retrieved from the Data Archive server named thevax at one-hour intervals, starting from midnight yesterday to midnight today.
The function displays the time stamp for each value in the column to the left of the calculated value.