Scenario 1: Use hourly and daily reports

You can use the AnalogSummaryHistory view to regularly track your plant's productivity. For example, you can answer questions such as:

• What was the peak temperature each hour?

• How much product did we produce today?

What is Analog Summary?

For analog data (such as temperature of a boiler or volume within a tank), you can retrieve summary data using the AnalogSummaryHistory view. For even faster retrieval, you can configure the tags to be stored with specific summary data and retrieve that summary data later. You can use a variety of available summary statistics, including:

• Time-weighted average

• Standard deviation

• First, last, minimum, or maximum value for a timestamped period

About the AnalogSummaryHistory View

AVEVA Historian stores historical data in history blocks rather than in the database itself. The data is accessible via extension tables.

With AnalogSummaryHistory, you can query summary statistics for analog tags. The AnalogSummaryHistory view lets you return multiple statistics for a single tag within one query.

Example: Creating a Daily Report

The following query returns the minimum, maximum, and average values for the R31.ReactTemp tag for two days of data at 24-hour resolution.

SELECT StartDateTime, TagName, Minimum, Maximum, Average

FROM AnalogSummaryHistory

WHERE TagName='R31.ReactTemp'

AND StartDateTime >= '2015-08-21'

AND EndDateTime <= '2015-08-23'

AND wwResolution=24*60*60*1000

The results are: