It's all about the answers!

Ask a question

How to create a burnup report for closed work items in BIRT?


1
1
Taki Nakajo (1.1k1945) | asked Jul 15 '14, 2:49 a.m.
A customer is trying to create a burnup report for opened and closed work items in BIRT. RTC version is 4.0.3.

Data Set retrieves like the below. 'CLOSE_COUNT' is a computed column ( Aggregation:RUNNINGSUM, Expression:row["WI_COUNT"].

DueDate     WI_COUNT     CLOSE_COUNT
2014/06/01  1            1
2014/07/11  1            2
2014/07/01  1            3
2014/06/21  1            4
2014/07/13  1            5

Q1) How can I sort by "DueDate" in the Data Set?

When he created a bar chart ( Category (X) series : row["DUE_DATE"], Date Sorting: Ascending, Grouping Type:DateTime, Unit:Days, Interval:1, Aggregate Expression:Sum), 
The bar chart is not sorted by row["DUE_DATE", it looks like order by data source.

DueDateY

DueDateX
Duedate

Q2) How can I sort by "DueDate" to show aggregate sum in Bar chart?


Comments
Taki Nakajo commented Jul 16 '14, 1:18 a.m.

 Does anyone know how-to?

One answer



permanent link
Rafik Jaouani (5.0k16) | answered Jul 17 '14, 9:38 a.m.
JAZZ DEVELOPER
I will need a copy of your report design file.

Comments
Taki Nakajo commented Jul 18 '14, 7:30 a.m.

I am waiting for the customer uploading the report design file. 


Taki Nakajo commented Jul 23 '14, 8:13 p.m.
After sending the report design file to Raflik, the comment from him as the below:
--------------------

The attached report is not the same as the one shown in the forum.

The X-Axis value is set to:
var dates = new Date();
if(row["DUE_DATE"] !=null){
    dates = row["DUE_DATE"];
}else{
   dates = new Date("1970/01/01 0:00:00");
}
Which is wrong as it does not seem to return any value.
User should create a computed column in the data set and use it for both sorting and display in the x-axis.

Rafik Jaouani 
--------------------

Your answer


Register or to post your answer.