Dundas Chart for ASP.NET
GroupByAxisLabel(String,String,String) Method
See Also  Example Send comments on this topic.
Dundas.Charting.WebControl Namespace > DataManipulator Class > GroupByAxisLabel Method : GroupByAxisLabel(String,String,String) Method


formula
The formula(s) to be used for calculating the "grouped" data point values. Multiple formulas can be specified by using comma-separated values.
Grouping formula.
inputSeriesName
The name(s) of series  that will be grouped.
Comma separated input data series names.
outputSeriesName
The name(s) of the series that will store the grouped data points. If a series does not exist it will be created; if it does exist it will first be cleared of all data before storing grouped points. Must be the same number of series as inputSeriesName or an exception will be thrown .
Comma separated output data series names.

Enterprise Edition Only Feature. Groups series data by axis labels using one or more formulas. Output series are used to store the grouped data points.


Grouping by X value, when it’s a string (stored in AxisLabel property).

Syntax

Visual Basic (Declaration)  
Public Overloads Sub GroupByAxisLabel( _
   ByVal formula As String, _
   ByVal inputSeriesName As String, _
   ByVal outputSeriesName As String _
) 
Visual Basic (Usage) Copy Code
Dim instance As DataManipulator
Dim formula As String
Dim inputSeriesName As String
Dim outputSeriesName As String
 
instance.GroupByAxisLabel(formula, inputSeriesName, outputSeriesName)
C#  
public void GroupByAxisLabel( 
   string formula,
   string inputSeriesName,
   string outputSeriesName
)

Parameters

formula
The formula(s) to be used for calculating the "grouped" data point values. Multiple formulas can be specified by using comma-separated values.
Grouping formula.
inputSeriesName
The name(s) of series  that will be grouped.
Comma separated input data series names.
outputSeriesName
The name(s) of the series that will store the grouped data points. If a series does not exist it will be created; if it does exist it will first be cleared of all data before storing grouped points. Must be the same number of series as inputSeriesName or an exception will be thrown .
Comma separated output data series names.

Example

The following sample demonstrates how to group together company sales by sales person. We will assume that two series named "Sales_West" and "Sales_East" both store numerous data points that measure a volume of sales, and that the names of sales people are used for axis labels. Grouped data points are then stored in two series named "GroupedSales_West" and "GroupedSales_East".
Visual Basic Copy Code
Imports Dundas.Charting.WebControl<CRLF> ...<CRLF><CRLF>' Group data by axis label<CRLF>Chart1.DataManipulator.GroupByAxisLabel("SUM", "Sales_West
C# Copy Code
using Dundas.Charting.WebControl;<CRLF>  ...<CRLF><CRLF>// Group data by axis label<CRLF>Chart1.DataManipulator.GroupByAxisLabel("SUM", "Sales_West

Remarks

Data points that have the exact same X-axis label (determined by the AxisLabel property) are grouped together into one data point. This new data point has Y-value(s) that are determined by the applied formula(s). Note that axis label comparisons are case sensitive.

The grouped data points are also sorted. For example, grouped data points with a "John" label will be displayed before grouped data points with a "Mark" label.

The first specified formula is the default, and is applied to all Y-values that are not calculated using subsequent formulas. Formulas specified after the default formula must have a "value" prefix to identify which value they should be applied to. For example, an expression of "SUM, Y2:AVE" means that an average of secondary Y-values will be calculated, and a sum of all other Y-values will be calculated. See Table1  for a listing of possible formulas and their descriptions.

Formulas are not applied to X-values, only to Y-values.

If a specified output series has not been created and added to the SeriesCollection when this function call is made it will be created and added to the collection automatically, and have default series properties (e.g. column chart type, etc.). In addition, the ChartArea property of the series is set to "Default", and if a chart area with the name "Default" exists in the ChartAreasCollection it will be used to draw the chart. If there is no chart area with this name the first ChartArea object in the collection will be used to display the series.

All data points in the given series are grouped (i.e. it is not possible to group only some of a series' data points).

Empty data points will be ignored or treated as zeros, depending on the IgnoreEmptyPoints property (by default IgnoreEmptyPoints is True).

Formula   Description Used for X-Value
AVE The average value of all data points within the given interval. No.
MAX The maximum value of all data points within the given interval. No.
MIN The minimum value of all data points within the given interval. No.
SUM The total value of all data points within the given interval. No.
LAST The last value of all data points within the given interval. Yes. New data points are drawn at the right-most margin of intervals.
FIRST The first value of all data points within the given interval. Yes. New data points are drawn at the left-most margin of intervals.
HiLoOpCl Calculates the largest, smallest, opening and closing values. Opening value is the first value in the interval, while the closing value is the last value for the interval.

NOTE: this formula returns four Y-values, and should only be used for chart types that use four Y-values (e.g. Candlestick charts)
No.
HiLo The largest and smallest of all data points within the given interval.
 
NOTE: this formula returns two Y-values, and should only be used for chart type that use two Y-values (e.g. Bubble charts).
No.
Count The number of data points that have been grouped into one point. No.
DistinctCount The number of data points that have been grouped into one point. Data points that have the same primary Y-values are considered one point. No.
Variance The variance between all data points within the given interval. No.
Deviation The deviation between all data points within the given interval. No.
Center The deviation between all data points within the given interval. Yes. New data points are drawn at the center of intervals.

        Table 1 - Formulas.

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2001 - 2009 Dundas Data Visualization, Inc. and others.