Skip to main content



      Home
Home » Archived » BIRT » Problem with Line Chart with Null Data points
Problem with Line Chart with Null Data points [message #93133] Sun, 20 November 2005 04:25 Go to next message
Eclipse UserFriend
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 , Chart fails to generate and I receive error :

"There are errors on the report page:
+ There are error(s) in Chart:null
Error0 : Error.ExtendedItemRenderingError(1 time)detail: There are
problems(s) rendering Chart extended item .Cannot define all null values
on a plot"


I remember in JCharts i had to use Double.NaN in place on Null, so the
chart will be generated and those points will not be plotted.

In BIRT, i tried to put Number.NaN in place on each Null value, but no way.

How can I plot null data points ?

thanks
Mohamed Arafat
Re: Problem with Line Chart with Null Data points [message #93242 is a reply to message #93133] Mon, 21 November 2005 04:15 Go to previous messageGo to next message
Eclipse UserFriend
Hi Mohamed,

This problem has been fixed, did you try with the latest nightly build?

Thanks,

David

"Mohamed Arafat" <arafat_eg2000@yahoo.com> wrote in message
news:70e6159113a4c339c1bebf03d3f587a0$1@www.eclipse.org...
>
> 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 , Chart fails to generate and I receive error :
>
> "There are errors on the report page: + There are error(s) in Chart:null
> Error0 : Error.ExtendedItemRenderingError(1 time)detail: There are
> problems(s) rendering Chart extended item .Cannot define all null values
> on a plot"
>
> I remember in JCharts i had to use Double.NaN in place on Null, so the
> chart will be generated and those points will not be plotted.
>
> In BIRT, i tried to put Number.NaN in place on each Null value, but no
> way.
>
> How can I plot null data points ?
>
> thanks
> Mohamed Arafat
>
>
Re: Problem with Line Chart with Null Data points [message #93629 is a reply to message #93242] Tue, 22 November 2005 02:21 Go to previous messageGo to next message
Eclipse UserFriend
Hi David

Thanks for your help at line chart problem with null values. <br>
Now I use latest nightly build (18 Nov 2005), It generates the chart but
in the wrong way. <br> <br>

When I have null value (data point)in one date (X-Axis) it should not
plot so the line should be disconnected at this point.

Now BIRT shifts values after null so it gives data points values in the
wrong dates. In this way the chart is not correct.

Ad the situation is the same for the other problem (for a date i have data
from some of the lines -groups- not all), it also shifts the points.

I appreciate any comments from you and other BIRT users.

Thanks & Regards
Mohamed Arafat
Re: Problem with Line Chart with Null Data points [message #93690 is a reply to message #93629] Tue, 22 November 2005 04:15 Go to previous messageGo to next message
Eclipse UserFriend
Hi Mohamed,

This sounds like a bug, could you please file a bugzilla entry for it, and
we will fix it.

Thanks,

David

"Mohamed Arafat" <arafat_eg2000@yahoo.com> wrote in message
news:da16b1ecfc80ceb18398e295b3434d4c$1@www.eclipse.org...
>
> Hi David
>
> Thanks for your help at line chart problem with null values. <br>
> Now I use latest nightly build (18 Nov 2005), It generates the chart but
> in the wrong way. <br> <br>
>
> When I have null value (data point)in one date (X-Axis) it should not
> plot so the line should be disconnected at this point.
> Now BIRT shifts values after null so it gives data points values in the
> wrong dates. In this way the chart is not correct.
>
> Ad the situation is the same for the other problem (for a date i have data
> from some of the lines -groups- not all), it also shifts the points.
>
> I appreciate any comments from you and other BIRT users.
>
> Thanks & Regards
> Mohamed Arafat
>
>
>
>
Re: Problem with Line Chart with Null Data points [message #93765 is a reply to message #93690] Tue, 22 November 2005 05:29 Go to previous messageGo to next message
Eclipse UserFriend
Hi David

I put a bug entry for that . Bug#117456.

Thanks
Mohamed Arafat
Re: Problem with Line Chart with Null Data points [message #96462 is a reply to message #93765] Mon, 05 December 2005 01:10 Go to previous messageGo to next message
Eclipse UserFriend
Hi,

Zhiqiang did an effort to fix it, but still there are bug with this chart.
I put a comment to bugzilla.

help is really appreciated.

Note : comment sent to bugzilla is attached here.
thanks
Mohamed Arafat
---------------------------------------------
Bug is not fixed. I use 1 Dec 2005 nightly build , It seems what you did
is
sorting values (data points) so null values come at the end, regardless
what
sorting user may use in SQL.

I have a chart showing the trend over time so data is sorted by date (X-
axis),
now the chart is showing null values at the end of the x-axis (where
should be
the latest value), so the chart is wrong and misleading.



data sample (real world data)
Survey Date Pipe Pressure Value
15-Apr-1990 X 880
15-Apr-1990 Y 0
15-Apr-1990 Z 0
30-Apr-1990 X 50
30-Apr-1990 Y 40
10-May-1990 X 650
10-May-1990 Y 75
21-Aug-1992 X 1,200
21-Aug-1992 Y 800
16-Sep-1997 X 1,050
16-Oct-1997 X 1,015
22-Feb-2002 X 900
22-Feb-2002 Y 200
10-Aug-2003 X 970
10-Aug-2003 Y
20-Nov-2004 X 970
20-Nov-2004 Y 80


Three pipes in the same equipment, should be surveyed for pressure, here
you
have one null value and in some dates some of the pipes were surveyd not
all.
the chart generated for this data is wrong. this chart should show the
pressure trend over time.

help with this bug is highly appreciated.

Thanks
Mohamed Arafat


-------------------------------------------------
Re: Problem with Line Chart with Null Data points [message #96635 is a reply to message #96462] Mon, 05 December 2005 12:32 Go to previous messageGo to next message
Eclipse UserFriend
Hi Mohamed,

If the bug isn't fixed, please reopen it. Can you also attach a screenshot
highlighting what is wrong with it?

Thanks,

David

"Mohamed Arafat" <arafat_eg2000@yahoo.com> wrote in message
news:53052ecb2b89caaec3eef80befff22a2$1@www.eclipse.org...
> Hi,
>
> Zhiqiang did an effort to fix it, but still there are bug with this chart.
> I put a comment to bugzilla.
> help is really appreciated.
>
> Note : comment sent to bugzilla is attached here.
> thanks
> Mohamed Arafat
> ---------------------------------------------
> Bug is not fixed. I use 1 Dec 2005 nightly build , It seems what you did
> is
> sorting values (data points) so null values come at the end, regardless
> what
> sorting user may use in SQL.
>
> I have a chart showing the trend over time so data is sorted by date (X-
> axis),
> now the chart is showing null values at the end of the x-axis (where
> should be
> the latest value), so the chart is wrong and misleading.
>
>
>
> data sample (real world data)
> Survey Date Pipe Pressure Value 15-Apr-1990 X 880
> 15-Apr-1990 Y 0
> 15-Apr-1990 Z 0
> 30-Apr-1990 X 50
> 30-Apr-1990 Y 40
> 10-May-1990 X 650
> 10-May-1990 Y 75
> 21-Aug-1992 X 1,200
> 21-Aug-1992 Y 800
> 16-Sep-1997 X 1,050
> 16-Oct-1997 X 1,015
> 22-Feb-2002 X 900
> 22-Feb-2002 Y 200
> 10-Aug-2003 X 970
> 10-Aug-2003 Y 20-Nov-2004 X 970
> 20-Nov-2004 Y 80
>
>
> Three pipes in the same equipment, should be surveyed for pressure, here
> you
> have one null value and in some dates some of the pipes were surveyd not
> all.
> the chart generated for this data is wrong. this chart should show the
> pressure trend over time.
>
> help with this bug is highly appreciated.
>
> Thanks
> Mohamed Arafat
>
>
> -------------------------------------------------
>
Re: Problem with Line Chart with Null Data points [message #96934 is a reply to message #96635] Wed, 07 December 2005 05:12 Go to previous message
Eclipse UserFriend
Hi,

The bug is fixed, I did a mistake and did not sort the X-series data in
the chart.

The chart is excellent now.

Thanks

Regards
Mohamed Arafat
Previous Topic:How to insert/remove table columns dynamically?
Next Topic:trying to get BIRT working in my RCP project
Goto Forum:
  


Current Time: Tue Jul 22 02:52:36 EDT 2025

Powered by FUDForum. Page generated in 0.10358 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top