How to create a chart with aggrecate function

jkoo · Post by **jkoo** » Fri Nov 18, 2011 8:58 pm

Hi,

Is it possible to create the following chart?
1. In orders table,
X axis: Months (1~2 or Jan~Dec)
Y axis: Number of orders(base on OrderDate) at that month

2. In Employees table
X axis : City
Y axis : Number of employees lives that city.

Thanks

Post by **Ivan** » Mon Nov 21, 2011 7:59 am

Hello,

jkoo wrote:Is it possible to create the following chart?
1. In orders table,
X axis: Months (1~2 or Jan~Dec)
Y axis: Number of orders(base on OrderDate) at that month

At this time it's only possible if the month will be as separate column of the table.

jkoo wrote:2. In Employees table
X axis : City
Y axis : Number of employees lives that city.

Please check the report sample in the attachment.

Thank you.

jkoo · Post by **jkoo** » Mon Nov 21, 2011 9:27 pm

Thanks. Your sample is very helpful to me.
One more question,
I'd like to create a chart to number of orders per month over a past year.
So I can create one by adding a calculated column(OrderMonth) from OrderDate.
But, for example, if there is no data on October, there is no "October" argument on chart.
Instead, is there any way to show 0 values for "October"arguemnt on the chart?
So is it possible to display 12 arguments always even if there is no data for that argument?

Thanks

Post by **HighAley** » Tue Nov 22, 2011 7:20 am

Hello.

jkoo wrote:Thanks. Your sample is very helpful to me.
One more question,
I'd like to create a chart to number of orders per month over a past year.
So I can create one by adding a calculated column(OrderMonth) from OrderDate.
But, for example, if there is no data on October, there is no "October" argument on chart.
Instead, is there any way to show 0 values for "October"arguemnt on the chart?
So is it possible to display 12 arguments always even if there is no data for that argument?

Unfortunately, there is no such feature. You should prepare data for chart by self.

Thank you.