Aggregation

The aggregation tab allows you to group data by the specified field and calculate aggregations, e.g. max, min, average, count, or sum.

The Group by property is used to specify field by which data will be grouped. Leave it empty if you don't need to group data.

Group the data source of the SharePoint chart 

The Aggregations section allows you to specify additional fields for each group and their calculated values:

Configure aggregations for the data source of the SharePoint chart 

You can carry out more complex aggregations over each group via JavaScript in aggregationSuccess handler. Also, if an error has occurred during aggregation, you can handle it in the aggregationError handler.