How to Apply Grouping and Aggregates in .NET Reports Charts

Some special features are commonly present in charts in reports. Data aggregation is a common concept when it comes to showing aggregated data in reporting. FlexReport's FlexChartField's data can be aggregated over the record source. Aggregation in all cases can be specified via the three collections: CategoriesGroups, SeriesGroups and Series. Suppose we have the following data set:

Country

City

Gender

Population

USA

Boston

M

10

…

…

Then we can have the following charts over aggregated data:

CategoriesGroups: CountrySeriesGroups: emptySeries: Sum(Population),Avg(Population)

CategoriesGroups: Country, SexSeriesGroups: emptySeries: Sum(Population),Avg(Population)

CategoriesGroups: CountrySeriesGroups: SexSeries: Sum(Population), Avg(Population)

In these examples, CategoriesGroups determine the number of points on the X axis. Series corresponds directly to FlexChartField’s Series. If SeriesGroups contains any groups, then for each FlexChartField’s Series, several Series will be created in FlexChartField. With FlexChartField, your reports' data aggregation will be easy, visual, and clear. To see the steps how data can be grouped and aggregated in FlexChartField, refer to the documentation. Read more about FlexReport.