Group By with Aggregation

In FusionCharts.Net, you can apply GroupBy and Aggregation operations to a DataModel at the same time.

Let's apply both the operations on the tabular data of a DataModel.

• Grouping to the Country column.

• SUM Aggregation function to the Sales column.

The code to apply grouping and aggregation function is shown below:

GroupColumn columnData = new GroupColumn { 

    "Country"

};

Aggregation aggregateSum = new Aggregation {

    "Sales", Aggregation.Function.SUM

};

DataModel totalSales = model.GroupingWithAggregation(columnData, aggregateSum);
COPY

In the above code:

• GroupColumn is a class.

• columnData is an object which holds information of the data to be grouped.

• Country is the column name from the above tabular data.

• Aggregation is a class.

• aggregateSum is the class object which holds information of the data to be aggregated.

• Sales is the column name on which the aggregation function will be applied.

• In Aggregation.Function.SUM, Function is an enum of Aggregation class which specifies the function to be applied on the data.

• DataModel is a class.

• totalSales is the object which holds the resultant data.

The output after running the above code looks like: