Computation Method For Changing Interval In Time Bucket

See previous W5 version guide


This document describes the computation method for changing interval in time bucket in CS Lucas system.


1) The time bucket interval as follows:

DAY                      Single day.
WEEK                  Monday to Sunday.
MONTH              1st to Month end (28th, 29th, 30th or 31st).
YEAR                   1st to 31st Dec.

2) As the time horizon in the time bucket series pans out into the future, the interval may be change from a smaller interval to a larger interval but not the other way around. E.g., you may change from DAY interval to WEEK interval but not from WEEK interval to DAY interval.

3) Since the interval between consecutive rows change, the system will, if necessary, shorten the subsequent (and larger) interval to accommodate this change. This may result in a period that is shorter than the stated interval for that period.

Example illustrated below for

a. Row 4     (change from DAY to WEEK interval)
b. Row 7     (change from WEEK to MONTH interval)
c. Row 10    (Change from MONTH to YEAR interval)




Leave a Reply


Your email address will not be published.

    Close Bitnami banner