How do chart aggregations work?

jsherriff

I have a chart that is using grouping, sorting, and an aggregate expression. But, no matter what I set the aggregate expression to (sum, median, etc) it appears to be aggregating using "average". Nothing I've set it to has any impact on the chart output. I want moving average. Any ideas what I'm doing wrong?

Attached is a zip containing an rptdesign and flatfile datasource example.

Thanks

Joel

jsherriff

I don't think this is going to work the way I want... Figuring I could accomplish the same thing by using a table aggregation, I created a table from the data, grouped on Month the same as in the chart, and added a MOVINGAVE aggregation but it's giving me the moving average of the individual values, not the moving average of the grouped values. For example, given

jan 1, 10
jan 2, 0
jan 3, 30
feb 1, 0
feb 2, 40
feb 3, 50
mar 1, 60
mar 2, 0
mar 3, 60


I'm looking for values aggregated by month with a moving average window of 2 expecting to get
jan 13.3 (10+0+30/3)
feb 21.6 (10+0+30+0+40+50/6)
mar 35 (0+40+50+60+0+60/6)

but instead I get
jan 15 (0+30/2)
feb 45 (40+50/2)
mar 30 (0+60/2)

is what I want possible?