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 in the summarization period must 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.

Part of an added field is displayed as a record field in PFM - Web Console. The added fields displayed on PFM - Web Console can be used as the fields to be displayed in a historical report.

The fields referred to in the record descriptions in this chapter are known as record-specific fields to distinguish them from additional fields generated when data is summarized.

Additional fields have the following field names:

The following table shows the suffix added to the PFM - Manager name, the suffix added to the corresponding PFM - View name, and the data stored in that field.

Table 5-3 List of suffixes in additional field names

Suffix added to the PFM - Manager nameSuffix added to the PFM - View nameField data
_TOTAL(Total)Sum of the field values in all records in the summary period
_COUNT--Number of records collected in the summary period
_HI(Max)Highest field value in the records in the summary period
_LO(Min)Lowest field value in the records in the summary period
Legend:
--: No additional field.

The table below lists the summary rules.

Table 5-4 List of summary rules

Summary rule nameSummary rules
COPYStores the actual field value of the most recent record in the summary period.
AVGStores the average field value of all field values in the summary period.
The average value is calculated using the following expression:

(sum-of-field-values)/(number-of-records-collected)

Additional field (Store database)
  • _TOTAL
  • _COUNT
Additional field (PFM - Web Console)
  • (Total)
HILOStores the highest value, lowest value, and average value of all field values in the summary period.
A record-specific field stores the average value.
The highest value, lowest value, and average value is calculated using the following expression:

(sum-of-field-values)/(number-of-records-collected)

Additional field (Store database)
  • _HI
  • _LO
  • _TOTAL
  • _COUNT
Additional field (PFM - Web Console)
  • (Max)
  • (Min)
  • (Total)
--No summarization