Change whether to include the hour in daily report calculations

<< Click to Display Table of Contents >>

Manual > Monitoring system construction guide > Construction of main functions > Daily reports > Customization of daily reports and aggregation functions >

Change whether to include the hour in daily report calculations

Define whether to include the hour (TimeRangeType property)

You can specify whether or not to include the hour in the calculation by setting the "TimeRangeType" property in the summary master file.

 

In particular, when setting daily reports, you must be aware of the TimeRangeType property.

 

[RAW::DAY]

TimeRangeType=TYPE2

...

 

Depending on the property value (TYPE1 or TYPE2), the following behavior will occur:

 

TYPE1 - Count from the current hour (including the current hour) to the next hour (excluding the next hour)

TYPE2 - Count from the current hour (excluding the current hour) to the next hour (including the next hour).

 

 

As an example, let's compare the behavior when it becomes 01:00.

 

TYPE1 - Data from 0:00:00 to 0:59:59 is aggregated and the record is added to the daily report aggregation log as a 0:00:00 record.

TYPE2 - Data from 0:00:01 to 1:00:00 is aggregated, and the record is added to the daily report aggregation log as a 0:00:00 record.

 

 

In addition, the TimeRangeType property for root logs has a special meaning. The TimeRangeType property for root logs affects the type of time range when TermOfValidity is specified for tag field masters and calculated field masters. For details, see the TermOfValidityDefinition property in the "Common Properties Section" of the Summary Master.

 

[RAW]

TimeRangeType=TYPE2

...

 

 

hint

How the hourly rate should be handled depends on the user's wishes, but TYPE2 is relatively more commonly adopted. The summary action of the standard framework of the frame library is also set to TYPE2 as the default setting (TYPE2 - Count from the current hourly rate (excluding the current hourly rate) to the next hourly rate (including the next hourly rate)).

 

hint

The timestamps of the records stored in the log data of the daily report aggregation log will always be 24 records ranging from 0:00:00 to 23:00:00. In the case of daily reports, the time may be written as 1:00 to 24:00, but since there is no concept of a timestamp of 24:00:00 in the log data, the time is always saved as 0:00:00 to 23:00:00. On the other hand, the specifications for the time notation on the screen and when printing can be freely set using the ReportTitleDateFormat property as follows:

 

Example) Display and print the time from 1:00 to 24:00

ReportTitleDateFormat= %[#H+1]

 

Example) Display and print the time from 0:00 to 23:00

ReportTitleDateFormat= %#H hour