It's all about the answers!

Ask a question

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

Taki Nakajo (1.1k2346) | 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"].

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.



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

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.
I will need a copy of your report design file.

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"];
   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.