Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » How to remove column in chart
How to remove column in chart [message #810617] Thu, 01 March 2012 10:25 Go to next message
Tomas Hudec is currently offline Tomas HudecFriend
Messages: 8
Registered: February 2012
Junior Member
Hi,

I created this chart but I wanna change it: hudi1.wz.cz/3/birt2.png

X axis contain number of calling sql query. Y axis contain date when this query was performed and this graph is grouping by my name of sql query. Now as you can see I have in Feb 14 white gap because query which was performed in March 1 was not performed in Feb 14. So how I can remove this white gap ? thx

Report message to a moderator

Re: How to remove column in chart [message #810865 is a reply to message #810617] Thu, 01 March 2012 16:16 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Can you put some sample data in an text file that I can build a report
off of to look at the issue? Post the sample data.

Jason

On 3/1/2012 5:25 AM, Tomas Hudec wrote:
> Hi,
>
> I created this chart but I wanna change it: hudi1.wz.cz/3/birt2.png
>
> X axis contain number of calling sql query. Y axis contain date when
> this query was performed and this graph is grouping by my name of sql
> query. Now as you can see I have in Feb 14 white gap because query which
> was performed in March 1 was not performed in Feb 14. So how I can
> remove this white gap ? thx

Report message to a moderator

Re: How to remove column in chart [message #811326 is a reply to message #810865] Fri, 02 March 2012 07:46 Go to previous messageGo to next message
Tomas Hudec is currently offline Tomas HudecFriend
Messages: 8
Registered: February 2012
Junior Member
sure:

Query | Count of perfom this query | Date when was this query perform
-------------------------------------------------------------------------------------

INSERT_SQL_STATISTIKA | 1 | 01-03-12 13:25:50
INSERT_HRU | 2 | 02-03-12 13:31:12
INSERT_ODPOVED | 15 | 02-03-12 13:31:12
GET_HRACA | 19 | 02-03-12 13:31:12
INSERT_ZADOST | 20 | 02-03-12 13:31:12
INSERT_HRU | 2 | 03-03-12 13:32:34
INSERT_ODPOVED | 15 | 03-03-12 13:32:34
GET_HRACA | 19 | 03-03-12 13:32:34
INSERT_SQL_STATISTIKA | 1 | 03-03-12 13:32:34
INSERT_SQL_STATISTIKA_CASY | 5 | 03-03-12 13:32:34
INSERT_ZADOST | 20 | 03-03-12 13:32:34
GET_HRACA_PODLE_JMENA | 28 | 04-03-12 13:34:42
INSERT_HRU | 15 | 04-03-12 13:34:42
INSERT_ODPOVED | 64 | 04-03-12 13:34:42
INSERT_SQL_STATISTIKA | 1 | 04-03-12 13:34:42
INSERT_SQL_STATISTIKA_CASY | 7 | 04-03-12 13:34:42
INSERT_ZADOST | 30 | 04-03-12 13:34:42


X-axis = Date (day)
y-axis = count
group by name of query

[Updated on: Fri, 02 March 2012 07:47]

Report message to a moderator

Re: How to remove column in chart [message #811333 is a reply to message #811326] Fri, 02 March 2012 07:56 Go to previous messageGo to next message
Tomas Hudec is currently offline Tomas HudecFriend
Messages: 8
Registered: February 2012
Junior Member
you have own sample data, you can use this: www.eclipse.org/forums/index.php/t/300875/ and just change value 614 to 0 and you will see white gap in the middle column

Report message to a moderator

Re: How to remove column in chart [message #811865 is a reply to message #811333] Fri, 02 March 2012 23:07 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
You can show a visual indication of a 0 value:
http://www.eclipse.org/birt/phoenix/project/notable2.6.php#jump_8
See modified attached example. If you want to remove it altogether that
will require some difficult scripting. Have a look at the second
example in the attached zip. Note that there is very little error
checking in the script.

Jason


On 3/2/2012 2:56 AM, Tomas Hudec wrote:
> you have own sample data, you can use this:
> www.eclipse.org/forums/index.php/t/300875/ and just change value 614 to
> 0 and you will see white gap in the middle column

Report message to a moderator

Previous Topic:How to display the toolbar in the Run Pattern
Next Topic:Aggregating "column based"
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 09:22:32 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly