How to create a burnup report for closed work items in BIRT?
![]()
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.
![]() ![]() ![]()
Q2) How can I sort by "DueDate" to show aggregate sum in Bar chart?
|
One answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Does anyone know how-to?