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 1: Creating a Daily Report with Delta Retrieval Mode

The following query returns the minimum, maximum, and average values for the R31.ReactTemp tag for two days of data at 24-hour resolution. Because no retrieval mode is specified, the retrieval mode is delta (the default retrieval mode for the AnalogSummaryHistory table).

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:

Example 2: Creating a Daily Report with Daily Retrieval Mode

The following query returns the average values for the R31.ReactTemp tag for four days of data at 24-hour resolution. Unlike the previous example, this uses the daily retrieval mode, which always has a resolution of a full local time day (86400000 milliseconds, except on days when daylight saving time begins or ends). Daily mode accounts for daylight saving time changes and adjusts the resolution for time change days accordingly. In the example below, daylight saving time begins on 2021-11-06, so that day has a resolution of 90000000 milliseconds (25 hours).

SELECT StartDateTime, wwResolution, TagName, Average

FROM AnalogSummaryHistory

WHERE TagName='R31.ReactTemp'

AND StartDateTime >= '2021-11-04'

AND EndDateTime <= '2021-11-08'

AND wwRetrievalMode='daily'

The results are: