Rockwell Automation FactoryTalk Metrics User Guide - Manual (Page 239)

Advanced Reporting Topics Chapter 7
1. Under Field Name, type a name for the new field.
2. Under Data Type, select the data type for the field.
3. Under SQL Expression..., do either of the following:
• Type the expression that will be evaluated to produce the
derived field.
• Choose one of available expressions:
Under Columns, click a column name.
Click Add Column to Expression.
The expression from the column appears under SQL
Expression....
If you do not select any expression in the Column list, and
then click Add Column to Expression, the first expression
in the list is added to the SQL Expression box.
13. Click Validate to check for errors.
If there are no errors, the Validate button becomes inactive.
14. Click Add.
The Column Selection page appears.
The derived field is displayed under Columns in Report Data
Source.
15. Click Next.
The Time Selection Toolbar page appears.
16. Under Timestamp Column for Time Selection Toolbar,
select a timestamp field.
17. Click Next.
The Time-series Format page appears.
Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014 239