How to use Aggregate functions in Series Editor

[Sandy Pham]

My users want to know how to use the Aggregate functions in the Series Editor.

As an example, our software has a bunch of Incidents that have categories (Hardware, Software, etc.). we want to create a pie chart that uses "Category" for the pie slices and COUNT(IncidentID) as the size of the slices.

The Argument Column is Category

The Value should be something like COUNT(IncidentID) or Total.Count(datasource, IncidentID)

But, neither worked for us.

What are we missing?

[Edward]

Please see the following topic:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=437

Thank you.

[Edward]

In that case the Totals is not acceptable, because the result will be counted on all records at once. In the case of the chart the data should be prepared via Data from other DataSource.

This DataSource can group, sort and count an aggregate functions for any DataSource from the reports Dictionary in the StimulReport.Net.
After getting the desired representation of the Data you may use Data from other DataSource as a DataSource for the chart.

Thank you.