|
Re: Aggregation Confusion [message #558002 is a reply to message #557782] |
Thu, 09 September 2010 17:42 |
|
Mark,
Can you log a bug for this?
Jason
On 9/8/2010 5:39 PM, Mark Victory wrote:
> Hi All,
>
> 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,
> Mark
>
|
|
|
|
Re: Aggregation Confusion [message #558233 is a reply to message #558043] |
Fri, 10 September 2010 15:27 |
|
I do not think its a bug, but an enhancement. Even if we do not change
the last function, we could add lastperiod or something like that, which
could do what you want.
Just to be clear. In your example if you have interval set to week and
you have to entries on the last day of the week, you want to sum them
and only them. Correct?
Jason
On 9/9/2010 5:51 PM, Mark Victory wrote:
> Thanks for the reply Jason,
>
> From my description this sounds like a bug to you?
>
> I don't want to cause work for BIRT folks if I just misunderstand the
> way the Aggregation/Grouping should work.
>
> Thanks again,
> Mark
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04058 seconds