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

Chapter 7 Advanced Reporting Topics
8. Clear the Show Tables check box to display only the database
views.
9. Select the OEEQWorkcell view.
The selected database view is the view used by the standard
FactoryTalk Metrics Workcell History report data source.
10. Click Next.
The Column Selection page appears.
11. Click Derived Field, and then click Add Derived Field.
The Add Derived Field dialog box appears.
12. Create a derived field called ActualCycleTimeTotals:
1. Under Field Name, type ActualCycleTimeTotals.
2. Under Data Type, leave Number.
3. Under SQL Expression..., type the following expression:
CASE WHEN
SUM(User.OEEQWorkCell.dTotalParts)=0 THEN 0
ELSE
SUM(User.OEEQWorkCell.dRunSec)/SUM(User.OEEQWorkCell.d
TotalParts)
END
4. Click Validate to check for errors.
5. If there are no errors, the Validate button becomes inactive.
6. Click Add.
The Column Selection page appears.
The derived field is displayed under Columns in Report
Data Source.
248 Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014