Problem with Line Chart with Null Data points

I have a Line Chart, with Date in X-Axis and Number in Y-Axis. There are
many lines in the same chart (Using series Grouping Key).

When there are Null values in Y-Axis (Null data points), in any of the
groups , I receive error in AP-Server log with BIRT VIEWER3.7:

WARNING: Exception
org.eclipse.birt.chart.exception.ChartException: Cannot define all null values on a plot
at org.eclipse.birt.chart.extension.datafeed.DataSetProcessorImpl.getMaximum(DataSetProcessorImpl.java:163)
at org.eclipse.birt.chart.computation.withaxes.PlotWith2DAxes.getMinMax(PlotWith2DAxes.java:327)
at org.eclipse.birt.chart.computation.withaxes.PlotWith2DAxes.computeCommon(PlotWith2DAxes.java:981)
at org.eclipse.birt.chart.computation.withaxes.PlotWith2DAxes.compute(PlotWith2DAxes.java:846)
at org.eclipse.birt.chart.factory.Generator.build(Generator.java:1108)
...

and I found topic that looked like same my situation ,
http://www.birt-exchange.org/org/forum/index.php/topic/16875-legend-problem-on-multiple-series-chart/

How can I plot null data points ?

Find more posts tagged with

Comments

mcremer

<blockquote class='ipsBlockquote' data-author="'fun'" data-cid="82064" data-time="1314692838" data-date="30 August 2011 - 01:27 AM">
I have a Line Chart, with Date in X-Axis and Number in Y-Axis. There are 
many lines in the same chart (Using series Grouping Key). 
 
When there are Null values in Y-Axis (Null data points), in any of the 
groups , I receive error in AP-Server log with BIRT VIEWER3.7: 
 
 
WARNING: Exception 
org.eclipse.birt.chart.exception.ChartException: Cannot define all null values on a plot 
at org.eclipse.birt.chart.extension.datafeed.DataSetProcessorImpl.getMaximum(DataSetProcessorImpl.java:163) 
at org.eclipse.birt.chart.computation.withaxes.PlotWith2DAxes.getMinMax(PlotWith2DAxes.java:327) 
at org.eclipse.birt.chart.computation.withaxes.PlotWith2DAxes.computeCommon(PlotWith2DAxes.java:981) 
at org.eclipse.birt.chart.computation.withaxes.PlotWith2DAxes.compute(PlotWith2DAxes.java:846) 
at org.eclipse.birt.chart.factory.Generator.build(Generator.java:1108) 
... 
 
 
and I found topic that looked like same my situation , 
<a class='bbc_url' href='https://www.birt-exchange.org/org/forum/index.php/topic/16875-legend-problem-on-multiple-series-chart/'>https://www.birt-exchange.org/org/forum/index.php/topic/16875-legend-problem-on-multiple-series-chart/</a> 
 
How can I plot null data points ? </blockquote>
 
 
Have you tried to map null to 0 (null is not a value and 0 is)

fun

The reason is set to null because i have cut the line of the graph where the data is lost(null).
And can't erasing 0 data in script because 0 exist as data .

This is data example . and there is any id
?Y-Axis Grouping Key is 'id' .
?X-Axis is 'date' .
?Drawing lines of the graph 'cost-A' and 'cost-B'

+

+
|??id????|??date???|?cost-A?|?cost-B?|
+

+
|??1001??|2011/01/01?|??0???|??null??|
+

+
|??1001??|2011/01/02?|??5???|??null??|
+

+
|??1001??|2011/01/03?|??10??|??null??|
+

+
|??1001??|2011/01/04?|??null?|???15??|
+

+
|??1001??|2011/01/05?|??null?|???20??|
+

mwilliams

Instead of using a line chart, try using a scatter plot chart and then make the connecting line visible for the series. I believe this will do what you want for your situation.

fun

Nothing changed my situation.
and connecting line is not good Curve and Color

mwilliams

Is this not the output you'd expect from the above data? (see attached)

If your data is not in straight lines like the above data you provided, you could use the curve fitting line instead of the series line. You can then set the color to the curve fitting line to whatever color you'd like for each series. The settings I used in the attached picture are to use the connecting line and to use the palette color for the line. If you show the line curve, it curves down when the data is null. If you use the curve fitting line, it does not do this.

fun

The graph is consistent with my expectations !

So I changed that from the line graph to a scatter plot chart with curve fitting line.

but yet warning message is (in AP-Server log 'ReportEngine_2011_08_26_14_11_38.log').

That occur in your environment?

And Can you attache the sample report?

fun

It will be a great help if someone find solution to resolve this issue.

fun

Is this issue Bug of EclipseBirt ??

http://www.eclipsezone.com/eclipse/forums/t68072.html

mwilliams

Here's the design file I used to create that image and the csv file (zipped).

fun

CSV data source???

CSV data source so that the exception will not be found.

It is already known.

Please reproduce this chart by using the sample data in BIRT.

If you can not resolve fundamental, it is considered to be a bug in the Birt.

Or just add that there is a need to develop a module to output a CSV from the database?

thank you.

mwilliams

There isn't a need to use a CSV file so that the exception is not found. But, because I was using your example data, I used a CSV file. The sample database doesn't have null values in it that I'm aware of, so reproducing the issue with this database would have been tough. I guess I could create a computed column that returned null for certain values to show it this way, but fundamentally, it's the same whether it's a CSV file or any other database. Let me know if you require an example that doesn't use a CSV file. Once the data is in a dataSet, though, it'll work the same from a CSV as from a JDBC.

danielkard

In birt 4, solve this with the option 'Connect Missing Values' (unchecked) in the Value (Y) Series. Null values will not display.
 
<a data-ipb='nomediaparse' href='https://www.dropbox.com/s/meosp0xjmrg3j1l/missing-values.png?dl=0'>Design image</a>
<a data-ipb='nomediaparse' href='https://www.dropbox.com/s/sokuob4h3zejyjj/report.png?dl=0'>Result image</a>