Rockwell-automation FactoryTalk Metrics User Guide Manual de usuario Pagina 249

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 272
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 248
Advanced Reporting Topics Chapter 7
7. Repeat the steps 1-6 to create the following summary
derived field:
Field name PartsPerMinuteTotal
Data type
Number
Add these columns to the expression
dTotalParts
dRunSec
Complete SQL expression
CASE WHEN
SUM(User.OEEQWorkCell.dRunSec)=0 THEN 0
ELSE
(SUM(User.OEEQWorkCell.dTotalParts)/SUM(User.OEEQWorkCe
ll.dRunSec))*60
END
Notes
This expression is identical to the one used with the PartsPerMinute derived field, but
every column name has a SUM function applied to it.
The two summary derived fields have been added to the report
data source.
13. Click Next until you reach the final page of the wizard, and
then click Finish.
The report data source has been created in the system.
The following picture shows a text report containing the
created summary derived fields.
Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014 249
Vista de pagina 248
1 2 ... 244 245 246 247 248 249 250 251 252 253 254 ... 271 272

Comentarios a estos manuales

Sin comentarios