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:
-
Name of an added field when it is stored in the Store database
Manager name of the fixed field with a suffix
-
Name of an added field when it is displayed in PFM - Web Console
View name of the fixed field with a suffix
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.
|
Manager name |
View name |
Stored 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.
|
Summary rule name |
Summary rule |
|---|---|
|
COPY |
Stores the field's value that is set in the most recent record within the summary period. |
|
AVG |
Stores 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)
Added field (PFM - Web Console)
|
|
-- |
No summarization |