Eclipse Community Forums: BIRT » HowTo sum (accumulate) aggregate values in chart BIRT Eclipse

Home » Eclipse Projects » BIRT » HowTo sum (accumulate) aggregate values in chart BIRT Eclipse(HowTo sum aggregate values in BIRT Eclipse)

Show: Today's Messages :: Show Polls :: Message Navigator

HowTo sum (accumulate) aggregate values in chart BIRT Eclipse [message #1008424]

Tue, 12 February 2013 12:34

Alberto Morando

Messages: 9
Registered: February 2013

Junior Member

Hi

I am new to the BIRT world and please sorry for the following questions (maybe they have obvious solutions) Smile

This is my setup:
BIRT version 2.2.1. I cannot update to a new version since I use it to get data from ClearQuest 7.1.2

I have a table that has two columns:

Date, ID

I have added a group based on Date and an aggregation on the number of items per group date.

The result is that at each date group I have the number of item per month saved in the aggregate value.

Now I need to accumulate per month to show in a chart (accumulated item per month in a chart)

Let´s say:
DATE ID
01/04/2012

01/04/2012 013
01/04/2012 023
----------
2 (aggregate value: Number of items in the month)

01/06/2012

01/06/2012 024
01/06/2012 035
01/06/2012 037
----------
3

I want to have a chart that have in X-axis : Date and in the Y- axis the running sum of the aggergate value of the table

following the above example: x: 01/04/2012 y: 2 x: 01/06/2012 y: 5 (the sum of the aggrgate value) and so on.

Could you please help me on that

Thanks

Alberto

Report message to a moderator

Previous Topic:	WebViewer in RCP
Next Topic:	HowTo sum (accumulate) aggregate values in chart BIRT Eclipse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Oct 26 08:14:23 GMT 2021

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter