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

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 272
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 245
Chapter 7 Advanced Reporting Topics
Field name PartsPerMinute
Data type Number
Add these columns to the expression
dTotalParts
dRunSec
Complete SQL expression
CASE WHEN
User.OEEQWorkCell.dRunSec=0 THEN 0
ELSE
(User.OEEQWorkCell.dTotalParts/User.OEEQWorkCell.dRunSe
c)*60
END
Notes PartsPerMinute is another way to represent the actual cycle time, in more familiar units.
The PartsPerMinute formula is as follows:
(dTotalParts/dRunSec)x60
When creating the PartsPerMinute field, use a CASE statement to avoid dividing by zero.
The three derived fields have been added to the report data
source.
14. Click Next.
The Time Selection Toolbar page appears.
15. Under Timestamp Column for Time Selection Toolbar,
select tStart to be used by the toolbar when filtering by time.
16. Click Next.
The Time-series Format page appears.
17. Under Supported Formats, leave the Table is not in a
time-series format option.
18. Click Next, and then click Finish.
The report data source has been created in the system.
246 Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014
Vista de pagina 245
1 2 ... 241 242 243 244 245 246 247 248 249 250 251 ... 271 272

Comentarios a estos manuales

Sin comentarios