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
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] |