Timeslice
Column Type = Single
The Timeslice column is used to define a custom pattern type..
Timeslice patterns are defined using key characters. These characters are:
| Symbol | Range | Definition |
Q |
1-4 | Quarter of the year (1=Jan to Mar, 2=Apr to Jun, etc.) |
M |
1-12 | Month of calendar year (1=Jan, 2=Feb, etc.) |
K |
1-53 | Week of the year (1=first week of the year). Note that week of the year numbering is based on ISO-8601. The first week of the year always contains 4 January. |
D |
1-31 | Day of month |
W |
1-7 | Day of week (1=Monday, 2=Tuesday, etc.) |
H |
1-24 | Hour of the day (1=midnight to 1:00am, 24=11:00pm to 12am midnight) |
! |
n/a | The "not" operator, e.g., !H1-6 means the data applies in hours other than 1-6 |
To define a pattern, begin with the desired symbol then specify the range. Use commas to separate symbols and semicolons for multiple patterns.
Examples of patterns are:
| Pattern | Interpretation |
| M1-2 | Value applies to January and February. |
| D1-5, H7-9 | Value applies to hours 7-9 for the days 1-5 of each month. |
| Q1,H3; Q3, H9-11 | Value applies to hour 3 in the first quarter and hours 9-11 in the third quarter. |
| !H4-9 | Value does not apply to hours 4-9. Value will apply to hours 1-3 and 10-24. |
Timeslice
Column