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

Analyzing FactoryTalk Historian Classic Data Chapter 4
3. Since we want to group the records by the hour portion of the
timestamp, select TimeStamp in the box on the right and
click the Grouping Interval button. The Format Field dialog
box is displayed. Select the HOUR format and click OK to
return to the Report Wizard.
4. Click Next to continue.
The Sort Order dialog box allows you to specify the order in which
the columns will be sorted and to calculate totals for columns. Since
we chose to group by TimeStamp and Description, those columns
automatically have a sort order applied to them.
1. To calculate the average downtime value, select the AVG
check box in the Downtime Seconds row.
Step 4: Sort the Records
Rockwell Automation Publication HIST-UM001K-EN-E-June 2014 63