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

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

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

Mon, 18 November 2013 16:41

Eclipse User

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 377 times)
Attachment: hoursburndown.xml
(Size: 1.41KB, Downloaded 193 times)

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

Thu, 21 November 2013 11:32

Eclipse User

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

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

Thu, 21 November 2013 13:28

Eclipse User

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.

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

Mon, 02 December 2013 16:45

Eclipse User

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!

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

Mon, 02 December 2013 17:13

Eclipse User

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

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

Mon, 02 December 2013 17:55

Eclipse User

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?

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

Tue, 03 December 2013 16:59

Eclipse User

Thanks Michael! Disabling grouping on the x-axis worked! I've also updated the defect with your information.

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

Tue, 03 December 2013 17:01

Eclipse User

No problem. Thanks for updating the bug! Smile

Previous Topic:	Filtering dataset with multiple filters
Next Topic:	text wrapping problem in merged cells

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Apr 26 04:30:19 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter