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
Creating a chart per month
Creating a chart per month
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.
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.