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