Stats Interval Temporal Filter

Overview

· The Stats Interval Temporal Filter is a date/time selection method.

· This temporal filter option will allow a designer to create widgets with fixed date range(s) that correspond to the department’s existing interval-based comparison periods (such as COMPSTAT).

· This capability allows a widget to age through a fixed period of time & then automatically progress to the next period following expiration of the current interval.

· The widgets refresh (as-scheduled) to provide up-to-date statistics.

· The Stats Interval Temporal Filter can be applied to Filter Widgets, Repeat Locations Widgets, Density Widgets and Multi-Layer Widgets.

· Examples:

o Interval-To-Date

o Current Interval

o Previous Interval

o Interval-To-Date (Last Year)

o Current Interval (Last Year)

o Previous Interval (Last Year)

How does the Stats Interval Temporal Filter work?

· The Interval Type drop down will allow you to choose between a pre-defined Existing Interval (list) or create a custom Manual Interval calendar structure.

o The Existing Interval option is pre-configured to utilize a default anchor date (e.g., Monday, January 2, 2012) & drop-down list for commonly requested time comparison period(s). Click the Select Interval drop down arrow to choose from the Existing Interval’s list.

o The Manual Interval will allow the user to create a custom calendar structure (i.e., specify the Anchor Date & Interval).

· An Anchor Date is the first date on a time comparison calendar. The Anchor Date establishes a calendar structure for the following time comparison period(s). Each interval is calculated consecutively from the Anchor Date through to the current date. For example, an anchor date of Monday, January 2, 2012 with an interval of 7 days, will result in 7-day comparison periods that begin on each Monday.

· An Interval is the (smallest) number of days to increment between consecutive time comparison periods. Typically, a multiple of 7 is used as the building block for comparing data between different time periods (i.e. 7 days, 14 days, 21 days, 28 days, etc). The Interval Duration box will allow the user to specify a custom # of interval day(s).

· The # of Intervals option provides the ability to create overlapping / rolling time comparison periods via incremental / aggregated intervals. The “Interval” (as mentioned above) defines the number of days within an interval, whereas the “# of intervals” will aggregate the # of consecutive intervals into a larger “rolling study period”. For instance, if a designer decides to use 7 days as the interval duration, and the number of intervals selected is 2, the temporal filter will include up-to 14 days, incremented by 7 days (when the previous interval’s time frame expires). NOTE: Most law enforcement agencies have mutually exclusive time periods that do not overlap day(s). As a result, the # of intervals parameter is typically “1” and the interval duration would be the length of the comparison period.

· The Interval Lag box will allow the user to track/monitor statistics from previous comparison periods. The interval lag defines the number of recent intervals to omit from the filter (Lag 0 = Current Interval, Lag 1 = Previous Interval, Lag X = Previous X Interval)

· The Use Partial Interval check box allows the inclusion of (partial) interval-to-date statistics (rather than whole interval comparison).

· The following example illustrates using the stats intervals to create three comparison widgets for the Most Recent 28 day period, Previous 28 day period and Previous Year 28 day period, assuming that today is Tuesday, July 2, 2013. The Anchor Date is Monday, January 2, 2012. The interval selected is 7 days. The # of intervals is 4 (4 x 7 days = 28 days). The Most Recent 28 day period for comparison is the last four complete intervals, beginning June 3, 2013 and ending on June 30, 2013 (lag = 0). The Previous 28 day period for comparison is the four complete intervals, beginning May 6, 2013 and ending on June 2, 2013 (lag = 4). The Previous Year 28 day period for comparison is the four complete intervals, beginning June 4, 2012 and ending on July 2, 2012 (lag = 52). Each seven days (on Tuesday each week) the comparison periods will move forward one week and re-tally.

· The Show Preview button will display a preview of the selected days/intervals on a calendar. Orange identifies the selected day(s). Alternating white/gray rows refer to adjacent/previous time intervals (which can be selected via the interval lag parameter).

The Stats Interval Temporal Filter dialogue.