Splits the elements based on the first split, then the resulting series are grouped based on the second split. The subValuesDateGrouping option adds the subValues to each resulting element grouped by the specified time interval. 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, _ ByVal elementNameFormatString As , _ ByVal subValuesDateGrouping As TimeIntervalAdvanced _ ) As Series
|Visual Basic (Usage)||Copy Code|
public Series SplitRegroupCalculate( TimeIntervalAdvanced firstSplit, TimeIntervalAdvanced secondSplit, Calculation calculation, elementNameFormatString, TimeIntervalAdvanced subValuesDateGrouping )
- 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.
- Providing a format string will evaluate the grouped element's xDateTime based on this format string and it will become the resulting element's name.
- The elements that are grouped to make up the resulting elements can be grouped by a time interval and added as subValues for each resulting element.