Aggregate daytime and nighttime data separately (TermOfValidityDefinition)
By setting the TermOfValidityDefinition property, you can define the period for the aggregation process, allowing you to perform aggregation by period (for example, aggregation by daytime and nighttime hours).
Specifically, you set the aggregation period (TermOfValidityDefinition property) in advance in the common property section ([COMMON]), and then prepare the [TermOfValidity] column in the tag field master file or calculated field master file and specify the aggregation period number. By making good use of this mechanism, you can use it, for example, when you want to calculate the total values for day and night separately.
For more information about the TermOfValidityDefinition property, see the "Common Properties Section" in the Summary Master.
Example) 1: Day 2: Night
[COMMON] TermOfValidityDefinition1=*/*/* 8:*:* - */*/* 21:*:* TermOfValidityDefinition2=*/*/* 22:*:* - */*/* 7:*:* ... |
|
00 |
01 |
02 |
03 |
04 |
05 |
06 |
07 |
08 |
09 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
noon |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
night |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example) 1: Day 2: Night 3: Peak
[COMMON] TermOfValidityDefinition1=*/7/1 *:*:* - */9/30 *:*:* && */*/* 8:*:* - */*/* 12:*:* || */7/1 *:*:* - */9/30 *:*:* && */*/* 16:*:* - */*/* 21:*:* || */10/1 *:*:* - */6/30 *:*:* && */*/* 8:*:* - */*/* 21:*:* TermOfValidityDefinition2=*/*/* 22:*:* - */*/* 7:*:* TermOfValidityDefinition3=*/7/1 *:*:* - */9/30 *:*:* && */*/* 13:*:* - */*/* 15:*:* ... |
July to September
|
00 |
01 |
02 |
03 |
04 |
05 |
06 |
07 |
08 |
09 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
noon |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
night |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
P |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
October to June
|
00 |
01 |
02 |
03 |
04 |
05 |
06 |
07 |
08 |
09 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
noon |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
night |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
P |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If you want to use this function to perform aggregation processing for daytime and nighttime hours, prepare a [TermOfValidity] column in the tag field master (or calculated field master), define separate rows for a field for all time periods, a field for daytime aggregation, and a field for nighttime aggregation, and set the desired aggregation period number in [TermOfValidity] of each row (the aggregation period number is the last number when defining TermOfValidityDefinition. If TermOfValidityDefinition is 1, specify "1").
Specifically, the period number is specified in the Tag (Calculation) Field Master File as follows:
[Name], ..., [TermOfValidity], ,... T000, ..., , ,... T000_DAY, ..., 1, ,... T000_NIGHT,..., 2, ,...
|
