Time boundaries for trends

The following table describes the time boundaries that can be used in trends, and explains the rules that define the boundaries of the trend time periods. All examples are shown with granularity of 1 second.

The rolling bounded time boundaries do not appear as settings in the user interface. However, they are included here to explain how the time boundaries behave when the system requires them to tight-fit historical periods to a spike period of a calendar day or in some cases a calendar week.

Time Boundary	Description
Calendar Day	Includes midnight of the transaction day up to but not including midnight of the next day. For example: If the current transaction is dated 2009-03-17 09:22:00, then the boundaries of its calendar day are 2009-03-17 00:00:00 – 2009-03-17 23:59:59 inclusive
Rolling Day	Includes everything greater than this second of the previous day up to and including the second of this current transaction. If the current transaction is dated 2009-03-17 09:22:00, then the boundaries of its rolling day are 2009-03-16 09:22:01 – 2009-03-17 09:22:00 inclusive
Calendar Week	Includes Sunday midnight up to but not including midnight of the following Sunday. For example: If the current transaction is dated (Tuesday) 2009-03-17 09:22:00, then the boundaries of its calendar week are (Sunday) 2009-03-15 00:00:00 – (Saturday) 2009-03-21 23:59:59 inclusive
Rolling Week	Includes everything greater than this second of the previous week up to and including the second of this current transaction. If the current transaction is dated (Tuesday) 2009-03-17 09:22:00, then the boundaries of its rolling week are (Tuesday) 2009-03-10 09:22:01 – (Tuesday) 2009-03-17 09:22:00 inclusive
Calendar Month	Includes midnight of the first of the month up to but not including midnight of the first of the next month. Note that calendar months vary in length. For example: If the current transaction is dated 2009-03-17 09:22:00, then the boundaries of its calendar month are 2009-03-01 00:00:00 – 2009-03-31 23:59:59 inclusive
Rolling Month	Includes everything greater than this second of this day of the month of the previous month up to and including the exact second of this current transaction. For example: If the current transaction is dated 2009-03-17 09:22:00, then the boundaries of its rolling month are 2009-02-17 09:22:01 – 2009-03-17 09:22:00
Rolling Bounded Week*	Used for historical periods when the spike period is of type calendar. For a particular day of the week, includes midnight of that day of the week up to but not including midnight of that same day of the next week. For example: If the current transaction is dated 2009-03-17 09:22:00, then the boundaries of its calendar day are 2009-03-17 00:00:00 – 2009-03-17 23:59:59. Also, the boundaries of the rolling bounded week that precedes the calendar day are: 2009-03-10 00:00:00 – 2009-03-16 23:59:59
Rolling Bounded Month*	Used for historical periods when the spike period is of type calendar. For a particular day of the month, includes midnight of that day of the month up to but not including midnight of that same day of the next month For example: If the current transaction is dated 2009-03-17 09:22:00, then the boundaries of its calendar day are 2009-03-17 00:00:00 – 2009-03-17 23:59:59. Also, the boundaries of the rolling bounded month that precedes the calendar day are: 2009-02-17 00:00:00 – 2009-03-16 23:59:59