Summary rules

For records of the PI record type, two types of data are stored in the Store database: the data collected at the interval set in Collection Interval, and the data summarized for a specific period of time (minute, hour, day, week, month, or year) according to a predefined rule. The type of summarization is defined for each field. This definition is called a summarization rule. Depending on the summarization rule, intermediate data used during the summarization period must sometimes be retained. In this case, a field for holding the intermediate data is added to a record in the Store database. This field is called an added field.

Some added fields are displayed as record fields in PFM - Web Console; these added fields can be used as fields to be displayed in historical reports.

To distinguish from added fields that are added by the process of summarization, the fields that are explained in the description of each record are called fixed fields.

The name of an added field is as follows:

The following table lists the suffixes for the Manager name, the suffixes for the corresponding View names, and the data that is stored in the fields.

Table 9-3 List of suffixes for added fields

Manager nameView nameStored data
_TOTAL(Total)Sum of the field's values in the records collected over the summary period
_COUNT--Number of records collected over the summary period
_HI(Max)Field's maximum value in the records collected over the summary period
_LO(Min)Field's minimum value in the records collected over the summary period
Legend:
--: There is no added field.

The following table lists and describes the summary rules.

Table 9-4 List of summary rules

Summary rule nameSummary rule
COPYStores the field's value that is set in the most recent record within the summary period.
AVGStores the field's average value over the summary period.
The formula is as follows:

(Sum of field values)/(number of collected records)

Added fields (Store database)
  • _TOTAL
  • _COUNT
Added field (PFM - Web Console)
  • (Total)
--No summarization