Eclipse Community Forums: BIRT » Line Chart displays null values as 0

Help

Home

Home » Archived » BIRT » Line Chart displays null values as 0(Line Charts)

Show: Today's Messages :: Show Polls :: Message Navigator

Line Chart displays null values as 0 [message #1195142]

Mon, 18 November 2013 21:41

Andi Hofmann

Messages: 4
Registered: November 2013

Junior Member

I have a line chart in a BIRT 4.3.1 report design that is supposed to display a Scrum hours burndown chart, which shows the number of hours worked by day in a sprint.

It uses an XML data source.

Obviously, for future dates I don't have any "hours worked" data points yet, therefore in the XML there's just no value for the days in question.

However, the BIRT line chart instead of omitting null values seems to convert them to 0 and connects the line to these 0 value data points.

This is not what I want. I just want my line to end where there are no more data points available.

Is that possible?

Attachment: HoursBurndown.rptdesign
(Size: 57.57KB, Downloaded 352 times)
Attachment: hoursburndown.xml
(Size: 1.41KB, Downloaded 163 times)

Report message to a moderator

Re: Line Chart displays null values as 0 [message #1201214 is a reply to message #1195142]

Thu, 21 November 2013 16:32

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Do you want all of the dates from the dataSet to show though? If not, you could simply use a filter on the chart.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Line Chart displays null values as 0 [message #1201400 is a reply to message #1201214]

Thu, 21 November 2013 18:28

Andi Hofmann

Messages: 4
Registered: November 2013

Junior Member

Yes, I want all of the dates in the dataset to be shown, not just the subset where there is also hours data available.

A Scrum sprint has a defined start and end date, and each day in the sprint should be shown in the chart, no matter if there is hours data available for it.

Report message to a moderator

Re: Line Chart displays null values as 0 [message #1219252 is a reply to message #1201400]

Mon, 02 December 2013 21:45

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

I thought what you have should have worked and it did back in earlier versions. Please file a bug for this in the bugzilla and post the bug info in here. Thanks!

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Line Chart displays null values as 0 [message #1219256 is a reply to message #1219252]

Mon, 02 December 2013 22:13

Andi Hofmann

Messages: 4
Registered: November 2013

Junior Member

I've created this defect in bugzilla: https://bugs.eclipse.org/bugs/show_bug.cgi?id=422144

Report message to a moderator

Re: Line Chart displays null values as 0 [message #1219257 is a reply to message #1219256]

Mon, 02 December 2013 22:55

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

I went to double check and created your chart from scratch in 4.3.1 and it works fine, as well. So, I looked at your chart vs the one I had created and found that when you have grouping enabled, as you do, that the marker is created. Without the grouping enabled, the line ends as expected. You can disable grouping by going to the select data tab and choosing the grouping and sorting button next to the x-axis field. The bug is still valid though because each grouping without an actual value shouldn't have a marker. Could you please update the bug with this info?

Michael

Developer Evangelist, Silanis

Report message to a moderator