Rockwell Automation FactoryTalk Historian Classic User Guide - Manual (Page 64)

Chapter 4 Analyzing FactoryTalk Historian Classic Data
NOTE
The weighted average (WAVG) function is an average that takes
into account the proportional relevance of each component
(typically over time), rather than treating each component
equally. Weighted average can be used in any table of
information where the values of a particular column should be
given more or less importance based upon the values of another
column. The weighted average function is ideal for calculating a
time-weighted average OEE value for multiple activity areas. See
the Weighted Average topic in online help for additional
information.
2. For this table, you are not interested in showing the individual
detail records that make up the average downtime; you want to
see only the average downtime per work cell values. Select the
Summary Only option at the bottom of the dialog box.
3. Click Next to continue.
The Format Style dialog box allows you to control the appearance of
the table.
1. The Report Style section of the dialog box lets you choose the
color scheme that will be applied to the table or to create a
custom style. For this tutorial, select the Access Northwind
Step 5: Format the Table
64 Rockwell Automation Publication HIST-UM001K-EN-E-June 2014