Creating reports and dashboards | Stimulsoft community forum

Hi there,

i got a Problem creating a Chart.

I need a chart that shows the average price per month of a specific product.

The DataTable looks like the following:

Orders


OrderDate ProductID Price Quantity
01.10.2007 123 10.50 5
01.10.2007 123 11.50 2
01.11.2007 123 10.50 8
01.11.2007 123 10.50 10
01.12.2007 123 9.50 15
01.12.2007 123 9.99 20
01.12.2007 123 8.89 50


What i need is to show up the Average Price of a product for every Month. here October, November, December.

Which is for October 75,5 / 7 = 10,78
November 189/18 = 10,50
December 786,80 / 85 = 9,25

Thx a lot

You need to add a field to your DataTable. This field must be of a string type and to contain the month and a year of the required Date, e.g.:

OrderDate GroupDate
10.01.2007 200701

It can be done, for example, before RegData() command.

When a table has such a filed, then the field can be used for grouping purposes in the "Data From Other DataSource" source. After that you can use this DataSource for building of the chart.

Thank you.