Summary rules

A summary record summarizes data collected at a specific interval (minute, hour, day, week, month, or year) and stores it in the Store database. The summarization is performed on the basis of the definition for operation specified for each field. Such definitions for operation are called the summary rules.

A field that is added to the Store database as a result of summarization is called an added field. Whether there is an added field and an added field's type depend on the summary rule. Some added fields are displayed as record fields in PFM - Web Console. Those added fields that are displayed in PFM - Web Console can be used as fields that are displayed in the historical reports.

To distinguish from the added fields that are added during summarization, the fields described in each record explanation are called fixed fields.

The name of an added field is as follows:

Name of an added field that is stored in the Store database

PFM - Manager name of the fixed field with a suffix
Name of an added field that is displayed in PFM - Web Console

PFM - View name of the fixed field with a suffix

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

Table 9‒2: List of suffixes for added fields
PFM - Manager name	PFM - View name	Stored data
`_TOTAL`	(Total)	Sum of the field's values in the records collected in the summary period
`_TOTAL_SEC`	(Total)	Sum of the field's values in the records collected in the summary period (applicable to the `utime` type)
`_COUNT`	--	Number of records collected in the summary period
`_HI`	(Max)	Maximum field value in the records collected in the summary period
`_LO`	(Min)	Minimum field value in the records collected in the summary period

Legend:: --: There is no added field.

The following lists and describes the summary rules.

Table 9‒3: List of summary rules
Summary rule name	Summary rule
`COPY`	Stores the field value in the most recent record within the summary period.
`AVG`	Stores the average field value in the summary period. The formula is as follows: (sum of field's values)/(number of collected records) Added field (Store database) `_TOTAL` `_TOTAL_SEC` (applicable to the `utime` type) `_COUNT` Added field (PFM - Web Console)^{#1, #2} (Total)
`ADD`	Stores the sum of the field's values in the summary period.
`HI`	Stores the field's maximum value in the summary period.
`LO`	Stores the field's minimum value in the summary period.
`HILO`	Stores the maximum, minimum, and average values of data in the summary period. The average value is stored in a fixed-field. The formula is as follows: (sum of field's values)/(number of collected records) Added field (Store database) `_HI` `_LO` `_TOTAL` `_TOTAL_SEC` (applicable to the `utime` type) `_COUNT` Added field (PFM - Web Console)^{#1, #2} (Max) (Min) (Total)
`%`	Stores the average field value in the summary period. This rule is mainly applied to a field for a percentage ratio. The formula is as follows: (sum of field's values)/(number of collected records) Added field (Store database) `_TOTAL` `_TOTAL_SEC` (applicable to the `utime` type) `_COUNT` Added field (PFM - Web Console)^#3 (Total)
`R`	Stores the average field value in the summary period. This rule is mainly applied to a field that indicates a quantity per second. The formula is as follows: (sum of field's values)/(number of collected records) When `delta` is specified for a `Real-Time` report, a special calculation that divides a difference by `Interval` is employed. Added field (Store database) `_TOTAL` `_COUNT` Added field (PFM - Web Console)^{#1, #2} (Total)
--	Not summarized.

#1

For a utime type field that contains _AVG in its PFM - Manager name, the (Total) field added in PFM - Web Console cannot be used in historical reports.

#2

For a field that contains any of the following character strings in its PFM - Manager name, the (Total) field added in PFM - Web Console cannot be used in historical reports:

_PER_, PCT, PERCENT, _AVG, RATE_TOTAL

#3

In the case of a utime type field only, the (Total) field added in PFM - Web Console can be used in historical reports.

To Page Top