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

Chapter 7 Advanced Reporting Topics
The Choose a Database Table or View page appears.
7. Select the desired database.
The table at the bottom of the dialog box is filled with the
tables and views that exist in the database.
8. Under Name, select the table or view to which you want to
create a connection.
9. Click Next.
The Column Selection page appears.
10. Select the column names that you want to add to the report
data source:
• Under Columns in Table or View, click a column name,
and then click .
The column is moved under Columns in Report Data
Source.
• To move several columns, press and hold Ctrl, click the
columns, and then click .
• To move all the columns, click .
11. (Optional). Under Columns in Report Data Source, rename
the columns:
1. Click the desired column, and then click Rename.
The name becomes highlighted for editing.
2. Change the name, and then press Enter.
12. (Optional). Click Derived Field, and then click Add Derived
Field.
The Add Derived Field dialog box appears.
A derived field is a new field that is a combination or
calculation of existing fields. For example, if your table has the
A, B, and C fields, you can create a D derived field containing
the value calculated from the expression ((A-B)/C * 100).
238 Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014