Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 131)

9
●
FactoryTalk Historian DataLink Function Reference
●
●
●
●
●
123
=PITimeDat("mytag",b1:b12,,"interpolated")
PITimeExpDat()
Retrieves FactoryTalk Historian point values based on an expression, and
corresponding to a specified array of time stamps, using the following
syntax:
PITimeExpDat(expression, timestamps, PIServer)
Arguments
Argument Explanation
expression (string) A FactoryTalk Historian calculation expression.
timestamps
(reference) A reference to an array of time stamps in FactoryTalk Historian time
format (monotonically increasing or decreasing for FactoryTalk
Historian 2 servers).
PIServer (string) The target FactoryTalk Historian server.
Returns
Sampled data. If the time stamps are in a single column, the data are
returned along a single column. If the time stamps are in a single row, the
data are returned along a single row.
Example:
The following calculates the square root of the value of the tag sinusoid
for the times located in cells B1 through B12 from the default FactoryTalk
Historian server:
=PITimeExpDat("sqr('sinusoid')",b1:b12,)