Cumulative Sum Control

Null Values in a Subgroup

A subgroup is composed of multiple samples. In some cases, sample values may not be known. This page describes how to handle null values. The cumulative sum control of the .Net Analytics package is of the following type:

Cumulative Sum (CuSumChart)

The series class of the cumulative sum chart is:

CuSumSeries

The subgroup class of a cumulative sum series is:

CuSumSubgroup

The first step is to include the necessary namespaces for the controls, add a new series, and add new subgroups.

Add Null Values to a Subgroup

Below, we will add values, including null values, to Cumulative Sum subgroups of a Cumulative Sum chart (named cscChart in the examples below). The process is similar for the other charts listed above:

[Visual Basic]

' Create a new subgroup

                  Dim cssSubgroup As New CuSumSubgroup()

                  ' Add some sample values to the subgroup

                  cssSubgroup.Add(New CuSumSample(0.4))

                  cssSubgroup.Add(New CuSumSample(0.2))

                  cssSubgroup.Add(New CuSumSample(0.5))

                  ' Exclude the last sample from calculations of the subgroup

                  cssSubgroup(2).ExcludeFromCalculation = True

                  ' Add the subgroup to the first series

                  cscChart.SeriesCollection(0).Add(cssSubgroup)

[Visual C#]

// Create a new subgroup

                  CuSumSubgroup cssSubgroup = new CuSumSubgroup();

                  // Add some sample values to the subgroup

                  cssSubgroup.Add(new CuSumSample(0.3));

                  cssSubgroup.Add(new CuSumSample(0.1));

                  cssSubgroup.Add(null);

                  // Add the subgroup to the first series

                  cscChart.SeriesCollection[0].Add(cssSubgroup);

                  

                  // Create another new subgroup

                  cssSubgroup = new CuSumSubgroup();

                  // Add some sample values to the subgroup

                  cssSubgroup.Add(new CuSumSample(0.4));

                  cssSubgroup.Add(new CuSumSample(0.2));

                  cssSubgroup.Add(new CuSumSample(0.5));

                  // Exclude the last sample from calculations of the subgroup

                  cssSubgroup[2].ExcludeFromCalculation = true;

                  // Add the subgroup to the first series

                  cscChart.SeriesCollection[0].Add(cssSubgroup);