| HowTo sum (accumulate) aggregate values in chart BIRT Eclipse [message #1008425] |
Tue, 12 February 2013 07:48 |
Eclipse User |
|
|
|
Hi
I am new to the BIRT world and please sorry for the following questions (maybe they have obvious solutions) 
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
|
|
|
Powered by
FUDForum. Page generated in 0.02226 seconds
Home