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

Chapter 7 Advanced Reporting Topics
TIP
You can rename the columns listed under Columns in Report
Data Source to make their names more intuitive (e.g., changing
sDescription to Workcell or Machine Name). To do it, click a
column, and then click Rename. The name becomes
highlighted for editing. Change the name and then press Enter.
12. Click Derived Field, and then click Add Derived Field.
The Add Derived Field dialog box appears.
NOTE
For more information on derived fields, see "Create a Report
Data Source (page 237)".
13. Create RunMinutes, ActualCycleTime, and
PartsPerMinute derived fields:
NOTE
When creating a derived field, you can use any legal SQL
statement that will return a single value. A useful construct to
use where there is the possibility of a divide-by-zero error is to
use a CASE statement.
1. Under Field Name, type RunMinutes.
The OEEQWorkcell view contains the Running Seconds
field, but it may be convenient to convert this to minutes.
The RunMinutes formula is as follows:
dRunSec/60
244 Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014