|Aggregation Confusion [message #557782]
||Wed, 08 September 2010 17:39
| Mark Victory
Registered: July 2009
I'm wondering if I misunderstand how aggregation should work in my bar chart.
My chart displays values over some amount of Days.
The value for each day is already a Sum. That is the "Value (Y) Series" Aggregation Expression is set to "Sum".
The Grouping for the Category (X) Series is set to be type DateTime. The Aggregate Expression is set to "Last".
If the unit for the Grouping is Days, the data displays correctly.
If, however, the grouping is something else - Weeks or Months for example, the result is a Sum of the values in the Week or Month. Since I set the Aggregate Expression to be "Last" I expected it to show the value from the "Last" day of the Week or Month.
Am I misunderstanding how the aggregation should work?
Hopefully my description makes sense and thanks A LOT,
Powered by FUDForum
. Page generated in 0.01764 seconds