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

8
●
Supplementary Information
●
●
●
●
●
91
Some functions also provide a field for a Filter Expression argument. You
can supply a filter expression to limit the values returned by a function, and
reference a filter expression in a worksheet cell.
Functions that may use these expressions include:
 Archive Value (page 34)
 Compressed Data (page 36)
 Sampled Data (page 39)
 Timed Data (page 41)
 Calculated Data (page 43)
 Time Filtered (page 48)
The following sections briefly outline FactoryTalk Historian expression
basics. FactoryTalk Historian DataLink supports all functional syntax,
operators and functions supported by the FactoryTalk Historian server.
For a full description of FactoryTalk Historian Performance Equations and
examples, see the FT Historian SE Applications User Guide.
Syntax
Follow these guidelines when writing FactoryTalk Historian expressions:
 Begin the expression with a single quote to force Excel to interpret the
expression as a string.
 Enclose tag names in the expression in single quotes.
 Type two single quotes for an expression that begins with a tag name.
Operators
The following operators are supported in FactoryTalk Historian
Expressions: