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:
-
Additional field contained in the Store database
PFM - Manager name of the record-specific field, plus a suffix
-
Additional field displayed in PFM - Web Console
PFM - View name of the record-specific field, plus a suffix
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.
|
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 |
- Legend:
-
--: No additional field.
The table below lists the 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: (total-sum-of-the-field-values)/(number-of-collected-records) Additional field (Store database)
Additional field (PFM - Web Console)
|
|
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: (total-sum-of-the-field-values)/(number-of-collected-records) Additional field (Store database)
Additional field (PFM - Web Console)
|
|
-- |
No summarization |