Report Ranges

When dealing with report ranges, there are 3 modes that need to be considered.

• Batch Mode – Run from the command line or Task Master
• Run-time Current Interval – Report screen in Run-time viewing current data
• Run-time Past Interval Stepping – Report screen in Run-time stepping back in time

In defining behaviors for the different modes, it is important to understand the effect of units on behavior. For example, there is a difference between showing 24 hours and showing 1 day, 7 days and 1 week, 30 days and 1 month, and so forth.  While the intervals are the same duration, the behavior will be different.  It should also be noted that all reports and intervals are based off of the current PC time.

The report range behavior for each mode and interval is defined below.

Batch Mode Behavior

Minute – Take the current minute plus the second Offset. Step back one minute and then backfill the number of minutes in the interval.  For example, consider a batch report with a 5-minute interval and a 0-second offset. If the report is run at 8:20:15 a.m., the report will step back to 8:20:00 a.m. and backfill 5 minutes of data.  Therefore, the report will have data from 8:15:00 a.m. to 8:20:00 a.m.

Hours – Take the current hour plus the minute Offset. Step back one hour and then backfill the number of hours in the interval.  For example, consider a batch report with a 6-hour interval and a 0-minute offset. If the report is run at 8:20 a.m., the report will step back to 8:00 a.m. and backfill 6 hours of data.  Therefore, the report will have data from 2:00 a.m. to 8:00 a.m.

Days – Take the current day and time. Step back less than one day to the Start at time and then backfill the number of days in the interval.  For example, consider a batch report with a 7-day interval and 00:00 (midnight) Start at time. If the report is run at 8:20 a.m. on 02/14/2014, the report will step back to midnight and backfill 7 days of data.  Therefore, the report will have data from 12:00 a.m. on 02/07/2014 to 12:00 a.m. on 02/14/2014.

Weeks – Take the current day and day of the week. Step back one day at a time until reaching the specified Starting on day at midnight and then backfill the number of weeks in the interval.  For example, consider a batch report with a 1-week interval and Sunday Starting on day. If the report is run at 8:20 a.m. on Friday 02/14/2014, the report will step back to midnight on Sunday 02/09/2014 and backfill 1 week of data.  Therefore, the report will have data from 12:00 a.m. on 02/02/2014 to 12:00 a.m. on 02/09/2014.

Months – Take the current day of the month.  Step back a day at a time until reaching the specified Starting on day and then backfill the number of months in the interval.  For example, consider a batch report with a 1-month interval and Starting on day set to 01. If the report is run on 02/14/2014 at 08:20 a.m., the report will back up to 02/01/2014 and backfill a month of data.  Therefore, the report will have data from 01/01/2014 to 02/01/2014.

Years – Take the current month in the year.  Step back to the first of the specified Starting in month and backfill the number of years in the interval.  For example, consider a batch report with a 1-year interval and Starting in month set to January. If the report is run on 01/14/2014 at 08:20 a.m., the report will back up to 01/01/2014 and backfill a year of data.  Therefore, the report will have data from 01/01/2013 to 01/01/2014.

Run-time Current Interval Behavior

Minutes – Take the current minute plus the second Offset. Step forward one minute and then backfill the number of minutes in the interval.  For example, consider a report screen with a 5-minute interval and a 0-second offset. If the report is loaded in Run-time at 8:20:15 a.m., the report will step forward to 8:21 a.m. and backfill 5 minutes of data.  Therefore, data from 8:16:00 a.m. to 8:21:00 a.m. will be displayed.  As the report continues to run through the minute, additional data coming in will be displayed.  At 8:21:00 the data window will shift forward one minute, and data from 8:17:00 a.m. to 8:22:00 a.m. will be displayed.  The data display shifts by one minute instead of the full 5-minute interval.

Hours – Take the current hour plus the minute Offset. Step forward one hour and then backfill the number of hours in the interval.  For example, consider a report screen with a 6-hour interval and a 0-minute offset. If the report is loaded in Run-time at 8:20 a.m., the report will step forward to 9:00 a.m. and backfill 6 hours of data.  Therefore, data from 3:00 a.m. to 9:00 a.m. will be displayed.  As the report continues to run through the hour, additional data coming in will be displayed.  At 9:01, the data window will shift forward one hour, and data from 4:00 a.m. to 10:00 a.m. will be displayed.  The data display shifts by one hour instead of the full 6-hour interval.

Days – Take the current day and time.  Step forward to the next Start at time.  (It may be in the current day or in the next day.)  Backfill the number of days in the interval.  For example, consider a report screen with a 7-day interval and 00:00 (midnight) Start at time.  If the report is loaded into Run-time at 8:20 a.m. on 02/14/2014, the report will step forward to 12:00 a.m. on 02/15/2014 and backfill 7 days of data.  Therefore, data from 12:00 a.m. on 02/08/2014 to 12:00 a.m. on 02/15/2014 will be displayed. As the report continues to run through the day, additional data coming in will be displayed. At 12:00 a.m. on 02/15/2014, the data window will shift forward one day, and data from 12:00 a.m. on 02/09/2014 to 12:00 a.m. on 02/16/2014 will be displayed.  The data display shifts by one day instead of the full 7-day interval.

Weeks – Take the current day and day of the week. Step forward one day at a time until reaching the specified Starting on day of week.  Backfill the number of weeks in the interval.  For example, consider a report screen with a 2-week interval and Starting on day set to Sunday. If the report is loaded in Run-time at 8:20 a.m. on 02/14/2014, the report will step forward to 12:00 a.m. on 02/16/2014 and backfill 2 weeks of data.  Therefore, data from 12:00 a.m. on 02/02/2014 to 12:00 a.m. on 02/16/2014 will be displayed.  As the report continues to run through the week, additional data coming in will be displayed. At 12:00 a.m. on 02/16/2014, the data window will shift forward one week, and data from 12:00am on 02/09/2014 to 12:00am on 02/23/2014 will be displayed.  The data display shifts by one week instead of the full 2-week interval.

Months – Take the current day of the month.  Step forward until reaching the specified Starting on day of the month.  Backfill the number of months in the interval.  For example, consider a report screen with a 6-month interval and Starting on day set to 01. If the report is loaded in Run-time on 02/14/2014, the report will step forward to 03/01/2014 and backfill six months of data. Therefore, data from 09/01/2013 to 03/01/2014 will be displayed.  As the report continues to run, additional data coming in will be displayed. On 03/01/2014, the data window will shift forward one month, and data from 10/01/2013 to 04/01/2014 will be displayed.

Years – Take the current month.  Step forward until reaching the specified Starting in month.  Backfill the number of years in the interval.  For example, consider a report screen with a 2-year interval and Starting in month set to January. If the report is loaded in Run-time on 02/14/2014, the report will step forward to 01/01/2015 and backfill 2 years of data.  Therefore, data from 01/01/2013 to 01/01/2015 will be displayed. As the report continues to run, additional data coming in will be displayed. On 01/01/2015, the data window will shift forward one year, and data from 01/01/2014 to 01/01/2016 will be displayed.

Run-time Past Interval Stepping Behavior

Minutes – Stepping back from the current interval will step back one minute and then then backfill the number of minutes in the interval.  For example, consider a report screen with a 5-minute interval and a 0-second offset. If the report is loaded in Run-time at 8:20:15 am, the current interval being displayed is from 8:16:00 a.m. to 8:21:00 a.m.  Therefore, the first step back will display 8:15:00 a.m. to 8:20:00 a.m., the next will display 8:14:00 a.m. to 8:19:00 a.m., and so forth.  At any time, when the Current Interval button is pressed, behavior will follow the "Run-time Current Interval Behavior" described above.

Hours – Stepping back from the current interval will step back one hour and then then backfill the number of hours in the interval.  For example, consider a report screen with a 6-hour interval and a 0-minute offset. If the report is loaded in Run-time at 8:20am, the current interval being displayed is from 3:00 a.m. to 9:00 a.m.  Therefore, the first step back will display 2:00 a.m. to 8:00 a.m., the next will display 1:00 a.m. to 7:00 a.m., and so forth.  At any time, when the Current Interval button is pressed, behavior will follow the "Run-time Current Interval Behavior" described above.

Days – Stepping back from the current interval will step back one day and then backfill the number of days in the interval.  For example, consider a report screen with a 7-day interval and Start at time set to 00:00. If the report is loaded in Run-time at 8:20 a.m. on 02/14/2014, the current interval being displayed will be from 12:00 a.m. on 02/08/2014 to 12:00 a.m. on 02/15/2014.  Therefore, the first step back will display 12:00 a.m. on 02/07/2014 to 12:00 a.m. on 02/14/2014, the next will display 12:00 a.m. on 02/06/2014 to 12:00 a.m. on 02/13/2014, and so forth.  At any time, when the Current Interval button is pressed, behavior will follow the "Run-time Current Interval Behavior" described above.

Weeks – Stepping back from the current interval will step back one week and then backfill the number of weeks in the interval.  For example, consider a report screen with a 2-week interval and Starting on day set to Sunday. If the report is loaded in Run-time at 8:20 a.m. on 02/14/2014, the current interval being displayed will be from 12:00 a.m. on 02/02/2014 to 12:00 a.m. on 02/16/2014.  Therefore, the first step back will go back one week and display from 12:00 a.m. on 01/26/2014 to 12:00 a.m. on 02/09/2014, the next will display from 12:00 a.m. on 01/19/2014 to 12:00 a.m. on 02/02/2014, and so forth.  At any time, when the Current Interval button is pressed, behavior will follow the "Run-time Current Interval Behavior" described above.

Months - Stepping back from the current interval will step back one month and then backfill the number of months in the interval, For example, consider a report screen with a 6-month interval and Starting on day set to 01. If the report is loaded in Run-time at 8:20 a.m. on 02/14/2014, the current interval being displayed will be from 09/01/2013 to 03/01/2014.  Therefore, the first step back will go back one month and display from 08/01/2013 to 02/01/2014, the next will display from 07/01/2013 to 01/01/2014, and so forth.  At any time, when the Current Interval button is pressed, behavior will follow the "Run-time Current Interval Behavior" described above.

Years - Stepping back from the current interval will step back one year and then backfill the number of years in the interval. For example, consider a report screen with a 2-year interval and Starting in month set to January. If the report is loaded in Run-time at 8:20 a.m. on 02/14/2014, the current interval being displayed will be from 01/01/2013 to 01/01/2015.  Therefore, the first step back will go back one year and display from 01/01/2012 to 01/01/2014, the next will display from 01/01/2011 to 01/01/2013, and so forth.  At any time, the Current Interval button is pressed, behavior will follow the "Run-time Current Interval Behavior" described above.