Eclipse Community Forums: BIRT » Aggregation Confusion

Home » Archived » BIRT » Aggregation Confusion

Wed, 08 September 2010 17:39

Eclipse User

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 #558002 is a reply to message #557782]

Thu, 09 September 2010 13:42

Eclipse User

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 #558043 is a reply to message #558002]

Thu, 09 September 2010 17:51

Eclipse User

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

Re: Aggregation Confusion [message #558233 is a reply to message #558043]

Fri, 10 September 2010 11:27

Eclipse User

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

Re: Aggregation Confusion [message #559982 is a reply to message #558233]

Mon, 20 September 2010 11:40

Eclipse User

Thanks for the reply, Jason.

I didn't notice it until today, sorry.

I entered a bug a while back but, as you suspected, it was closed as invalid with the comment:

"Aggregation on Y series will override that on X series. This is expected behavior."

I guess I don't understand how to do what I want. My data set contains multiple rows for each day. I need to sum the values of one of the columns for each day to produce the totals for that day.

What I do not want to do is sum the days to make Week or Month totals when the X Axis is grouped by week or month. I want the last day of each week or month to be the value when the grouping is by Week or Month.

The feels like something that would be pretty common but I haven't figured out how.
I must be missing something obvious. Smile

Thanks again for your help,
Mark

Re: Aggregation Confusion [message #560207 is a reply to message #559982]

Tue, 21 September 2010 10:53

Eclipse User

Mark,

Can you add a comment to the bug to suggest this as an enhancement? I do not see an easy way of doing this without scripting.

Jason

Re: Aggregation Confusion [message #626765 is a reply to message #557782]

Wed, 22 September 2010 13:32

Eclipse User

Thanks for the replies Jason,

The number for the bug I entered is 324918 and I asked in there to make it an enhancement request.

Mark

Previous Topic:	Get an Image from a Linux O.S to run a report
Next Topic:	Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 20:16:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter