Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Aggregation Confusion
Aggregation Confusion [message #557782] Wed, 08 September 2010 21:39 Go to next message
Mark Victory is currently offline Mark Victory
Messages: 133
Registered: July 2009
Senior Member
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 17:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 21:51 Go to previous messageGo to next message
Mark Victory is currently offline Mark Victory
Messages: 133
Registered: July 2009
Senior Member
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 15:27 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 15:40 Go to previous messageGo to next message
Mark Victory is currently offline Mark Victory
Messages: 133
Registered: July 2009
Senior Member
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 14:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 17:32 Go to previous message
Mark Victory is currently offline Mark Victory
Messages: 133
Registered: July 2009
Senior Member
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:
  


Current Time: Sun Sep 21 16:28:21 GMT 2014

Powered by FUDForum. Page generated in 0.02984 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software