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 name | Suffix added to the PFM - View name | Field 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 |
The table below lists the summary rules.
Table 5-4 List of summary rules
Summary rule name | Summary rules |
---|---|
COPY | Stores the actual field value of the most recent record in the summary period. |
AVG | Stores 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)
|
HILO | Stores 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)
|
-- | No summarization |