It's all about the answers!

Ask a question

rtc custom birt report datasets data in chart

pan radek (322) | asked Oct 28 '13, 3:46 p.m.
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.

Accepted answer

permanent link
sam detweiler (12.4k6180201) | answered Nov 02 '13, 2:15 p.m.
when I was having Birt custom report troubles,  I asked over in the Birt eclipse project forum.
pan radek selected this answer as the correct answer

One other answer

permanent link
pan radek (322) | answered Nov 02 '13, 12:10 p.m.
No one help?
Simply, I just need to know how to get data from eg. two datasets into common chart.
Data from second dataset shall display a trend line.

Your answer

Register or to post your answer.