Splits the elements based on the first split, then the resulting series are grouped based on the second split. A simple analogy is a stretch of measuring tape representing a timeline. The tape is cut into sections based on (first split), then the pieces are stacked on top of each other and cut again based on the second split. The resulting stacks are evaluated down to an element based on the specified calculation.
As a real world example, consider you have a series with web site traffic represented by an element for each time the website was visited including a date and time. This method can parse the data in a way that allows determining the traffic for each day of the week throughout the entire span of time. This means all the traffic going through the website on any monday would be calculated down to a single element, same for tuesday and so on.
This illustration shows how the data is arranged.
|Visual Basic (Declaration)|
Public Overloads Function SplitRegroupCalculate( _ ByVal firstSplit As TimeIntervalAdvanced, _ ByVal secondSplit As TimeIntervalAdvanced, _ ByVal calculation As Calculation _ ) As Series
|Visual Basic (Usage)||Copy Code|
public Series SplitRegroupCalculate( TimeIntervalAdvanced firstSplit, TimeIntervalAdvanced secondSplit, Calculation calculation )
- First split of the data.
- Second split used to group results from the first split.
- Calculation performed on elements when grouped by the second split into a single element.