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

2
●
Basics
●
●
●
●
●
19
 PI Server (page 20)
 Output Cell (page 20)
Tagname(s) or Expression
The Tagname(s) or Expression field is required by most functions to
evaluate FactoryTalk Historian point (tag) data or the results of a
FactoryTalk Historian expression (page 91). One or more tag names, or the
syntax of a FactoryTalk Historian expression may be:
 Typed directly in a field.
For example, sinusoid.
 Typed in one or more spreadsheet cells, which are then referenced in
the field.
For example, a reference to the array
Sheet1!$B$3:Sheet1!$B$4, which in turn contains the tag
name strings 'sinusoid and 'cdt158.
Note that cell references allow multiple tag names to be specified for a
function, whereas you cannot specify multiple tag names directly
unless the field is labeled Tagname(s).
Note that single quotes are added to each tag name to denote string
values in Excel. Both strings and time expressions referenced in cells should
be enclosed in single quotes. For example:
TimeEq('CD:M158','y' ,'t', "Manual") .
 Selected in the Tag Search dialog box (page 51), based on a search for
tags by name, alias or attribute.
Start Time
The beginning of a time range (page 21) over which the function is
evaluated, from Start Time to End Time. All event values corresponding to