PITimeFilterVal()
- Last UpdatedNov 21, 2022
- 1 minute read
- PI System
- PI DataLink 2023 SP1
- Visualization
Returns the amount of time that a performance equation evaluates to true during a specified time period.
Syntax
PITimeFilterVal(Expression, STime, ETime, TimeUnit, OutCode, RootPath)
Arguments
|
Argument |
Type |
Description |
|---|---|---|
|
Expression |
String |
A Boolean performance equation that the function evaluates. See Expressions. Reference a range of cells that contain expressions to return 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. |
|
TimeUnit |
String |
Time unit of the calculated result:
|
|
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 2 and 3. |
|
RootPath |
String |
The path to the data item referenced by the expression. See Data items. |
Example
=PITimeFilterVal($A$1,"y","t","seconds",0,"thevax")
Returns the number of seconds that the expression in cell A1 is true on the Data Archive server named thevax from midnight yesterday to midnight today.