Dundas Chart for Windows Forms
FilterTopN(Int32,String,String,String) Method
See Also  Example Send comments on this topic.
DundasWinChart Assembly > Dundas.Charting.WinControl Namespace > DataManipulator Class > FilterTopN Method : FilterTopN(Int32,String,String,String) Method


pointCount
The number of data points that the filtering operation will not remove (or mark as empty).
Number of top/bottom points to return.
inputSeriesNames
The name(s) of the series that will be filtered. For multiple series use a comma-separated list of names, and make sure that the series are aligned. An asterisk (*) may be used to filter all series in the series collection (in which case the outputSeriesName parameter must be empty)
Comma separated input series names.
outputSeriesNames
The name(s) of the series that store the filtered data. Make sure that the number of output series matches the number of input series, otherwise an exception will be thrown.
Comma separated output series names.
usingValue
The data point value of the first named series that is examined (e.g. "X", "Y", "Y2", etc.).
Defines which value of the point use in comparison (X, Y, Y2, ...).

Enterprise Edition Only Feature. Filters all data points in one or more series except for a specified number of points. The points that aren't filtered correspond to points in the first series that have the largest values.


Keeps only N top/bottom points of the series.

Syntax

Visual Basic (Declaration)  
Public Overloads Sub FilterTopN( _
   ByVal pointCount As Integer, _
   ByVal inputSeriesNames As String, _
   ByVal outputSeriesNames As String, _
   ByVal usingValue As String _
) 
Visual Basic (Usage) Copy Code
Dim instance As DataManipulator
Dim pointCount As Integer
Dim inputSeriesNames As String
Dim outputSeriesNames As String
Dim usingValue As String
 
instance.FilterTopN(pointCount, inputSeriesNames, outputSeriesNames, usingValue)
C#  
public void FilterTopN( 
   int pointCount,
   string inputSeriesNames,
   string outputSeriesNames,
   string usingValue
)

Parameters

pointCount
The number of data points that the filtering operation will not remove (or mark as empty).
Number of top/bottom points to return.
inputSeriesNames
The name(s) of the series that will be filtered. For multiple series use a comma-separated list of names, and make sure that the series are aligned. An asterisk (*) may be used to filter all series in the series collection (in which case the outputSeriesName parameter must be empty)
Comma separated input series names.
outputSeriesNames
The name(s) of the series that store the filtered data. Make sure that the number of output series matches the number of input series, otherwise an exception will be thrown.
Comma separated output series names.
usingValue
The data point value of the first named series that is examined (e.g. "X", "Y", "Y2", etc.).
Defines which value of the point use in comparison (X, Y, Y2, ...).

Example

The following sample code filters 2 chart series, and only 10 data points in both series are kept, these being the points that correspond to those of the first series that have the largest second Y-values. Series1 and Series2 are filtered, and the resulting data is stored in Series3 and Series4, respectively. We only display Series3 and Series4.
Visual Basic Copy Code
Imports Dundas.Charting.WinControl
...

    ' Filter out all points except 10 data points, that correspond to the first series with the largest Y values
    Chart1.DataManipulator.FilterTopN(10, "Series1,Series2", "Series3,Series4", "Y2")

...
C# Copy Code
using Dundas.Charting.WinControl
...

   
// Filter out all points except 10 data points, that correspond to the first series with the largest Y values.
   
Chart1.DataManipulator.FilterTopN(10, "Series1,Series2", "Series3,Series4", "Y2");
   
...   
 

Remarks

This method filters all data points from one or more series except for a specified number of points. The points that aren't filtered correspond to points in the first series that have the largest values.

The values in the first series that are examined are determined by the usingValue parameter (e.g. "", etc.).

Filtering should only be applied to multiple series that are aligned, otherwise an exception will be thrown (for information concerning alignment of data see the Aligning Data topic). Note also that multiple series are filtered using the values from the FIRST specified series. If two series must be filtered independently call the FilterTopN method twice using one series as a parameter.

IMPORTANT: the output series that stores the filtered data from the first input series will have its data points sorted by the value specified by the usingValue parameter. Since all output series are aligned this means that the data in each output series is ordered according to the sorting of the first output series.

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 "", and if a chart area with the name "" 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.

Filtered points can be either removed from a series (default) or displayed as empty points, depending on the FilterSetEmptyPoints value.

Filters are always applied to an entire series.

To filter a series and keep data points with the smallest values use another definition of this function that uses a getTopValues argument.

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

© 2009 All Rights Reserved.