Odbc data sets, E 254) – Rockwell Automation FactoryTalk Historian SE ProcessBook 3.2 User Guide User Manual

Page 272

Advertising
background image

FactoryTalk Historian ProcessBook User Guide

254

moving average to show a smoothed version of the same curve. The
moving average is built from the source tag using a data set that
recalculates an average point value over recurring intervals.

To create a moving average in a trend:

1. In Build mode, double-click the trend to open the Define Trend

dialog box.

2. Click the Tag Search arrow and choose FactoryTalk Historian

calculation to create a data set based on a tag.

3. Click New to add the data set and specify a Name and Description for

the data set that calculates the moving average.

4. Click Tag Search and select the tag you want to use as the basis for

the calculation.

5. In the Interval field, choose the calculation period for the average. A

new average tag value is computed at each interval over the plotted
time range.

6. Click Average in the Columns panel to select an average calculation,

and click OK.

7. Click OK to close the Define Trend dialog box.

ODBC Data Sets

FactoryTalk Historian ProcessBook uses the term ODBC data set for the
concept of an ODBC query that retrieves data from a relational database to
produce a group of data values organized into rows and columns and used
to build a trend or other element in a ProcessBook display. A data set is
identified within a ProcessBook by a unique name.

The data set name refers to the combination of an SQL query statement and
an ODBC Data Source with which to execute the query. The results of the
SQL query are organized into rows and columns. You may select any

Advertising