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

Advanced Reporting Topics Chapter 7
2. Under Data Type, leave Number.
3. In the Columns list, click dRunSec.
4. Click Add Column to Expression.
5. Under SQL Expression..., edit the expression as follows:
User.OEEQWorkCell.dRunSec/60
6. Click Validate to check for errors.
If there are no errors, the Validate button becomes inactive.
7. Click Add.
The Column Selection page appears.
The derived field is displayed under Columns in Report
Data Source.
8. Repeat the steps 1-7 to create the following derived fields:
Field name ActualCycleTime
Data type Number
Add these columns to the expression • dTotalParts
• dRunSec
Complete SQL expression
CASE WHEN
User.OEEQWorkCell.dTotalParts=0 THEN 0
ELSE
User.OEEQWorkCell.dRunSec/User.OEEQWorkCell.dTotalParts
END
Notes ActualCycleTime is the number of seconds in which one part was made. The actual cycle
time will only be measured when the workcell is running, and both good and scrap parts
are counted. The actual cycle time will be compared to the ideal cycle time. The
ActualCycleTime formula is as follows:
dRunSec/dTotalParts
When creating the ActualCycleTime field, use a CASE statement to exclude records where
dTotalParts equal zero.
Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014 245