rtc custom birt report datasets data in chart
I have a really hard nut to crack in creating birt report. Create something custom is really hard and tricky in this tool.
A. I need to create report which will contain a chart showing count workitems of type - open, in progress, closed. the report is parameterised so that a different sprint may be chosen, or a time range encompassing several sprints may be used.
Ok, this is quiet easy.
B. I need additional line on the chart which will be a count of all workitems from project start to today. Like a trend line or some level line.
The Scrum Delta report is used for tracking changes in the state of eg. Product Backlog, Sprint Items over time.
I have one data set for pt. A - WORKITEM_STATES
and I created second data set for pt. B LIVE_WORKITEM_CNT which getting WI_COUNT
I created a hidden label binding dataset B and script which fetching data into variable.
In dataset A I created computed column which contains scripted variable. This is only way what I find to combine data from different datasets.
Hmmm, but chart looks not as expected and I think it must be an easier way to do it.
How to get this two data sets data into one chart in a proper way?
Thanks for help in advance.