Syntax

GROUPPREDICTIVEWINDOWS(<string, date, number>; <string, date, number>; <string, date, number>; <date>; <number>)

Description

This function assigns IDs to events. It does that based on an event that defines the center of a time-based window (center-event) and all events in that window get assigned the ID of the center-event. It returns a two-element list for each event within the window: the timestamp of that event and the ID of the windows center event.

This is a group series function.

Example

Given the following raw data:

GroupName	Event	Date
1	a	Aug 1, 2014
2	b	Aug 2, 2014
3	c	Aug 3, 2014
4	d	Aug 4, 2014
5	e	Aug 5, 2014

Create a new worksheet and use the GROUPBY function with the constant "1" to make a single group.

GROUPBY(1)

Next use the GROUPPREDICTIVEWINDOWS function to create a two-element list for each event within a specified window. The two elements are the date used to create the OrderBy and the Window ID. This example creates a three day window from the specified center event "c" using the value 259200000 milliseconds.

Events = #RawData!Event
Window center event = "c"
Window ID = #RawData!GroupName
OrderBy = #Rawdata!Date
Window size in MS = 259200000

Ensure that values of the string data type are entered with quotation marks.

GROUPPREDICTIVEWINDOWS(#RawData!Event;"c";"#RawData!GroupName;#RawData!Date;259200000)

GROUPBY_Constant	Window
1	[Aug 2, 2014, 3]
1	[ Aug 3, 2014, 3]
1	[ Aug 4, 2014, 3]

Browser not supported