GROUPPREDICTIVEWINDOWS

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:

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

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