Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Gantt chart multiple timeframes per series
Gantt chart multiple timeframes per series [message #1007103] Mon, 04 February 2013 13:27 Go to next message
Hauke Luebbers is currently offline Hauke LuebbersFriend
Messages: 4
Registered: November 2012
Junior Member
Hi,

I would like to show more than just one time frame per Y-Axis series of my gantt chart.
For example, on the Y-Axis are hotel rooms and on the X-Axis are the time frames that indicate that the room is blocked.

Sadly BIRT has this bug when it comes to showing multiple time frames in one series with grouping on the Y-axis ( bugs.eclipse.org/bugs/show_bug.cgi?id=376935 ).

So it thought that adding a dynamic number of Y-series depending on the number of time frames could be a workaround.

Now there are two problems for me:

First, my data set looks like this:

Room  |  start  |  end
room1 | 12412341| 12541234
room2 | 12342432| 13341234
room1 | 22345234| 23341234
...


So I think I have to refactor the data set that I looks like this, right?

Room  |  start1  |  end1   | start2  | end2 
room1 | 12412341| 12541234 | 22345234| 23341234
room2 | 12342432| 13341234 | 0       | 0       


This structure would not be possible with SQL as I do not know how many columns I need, but I would have to refactor the data set using Javascript if I am not mistaken.

After that, I would need to add a dynamic number of Y-series to my gantt chart.
Is there some example how to do that for the newer BIRT versions? I only found jasonweathersby.sys-con.com/node/1200405/mobile and could not really get it to work in BIRT 4.2.1

I would be thankful for some input whether my thoughts are correct and maybe an example how I could add a series to a gantt chart?

Thanks in advance, regards,
Hauke
Re: Gantt chart multiple timeframes per series [message #1007218 is a reply to message #1007103] Tue, 05 February 2013 05:37 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

If I'm understanding what you're trying to do correctly, you could create a computed column in your dataSet that keeps a running count for each row that belongs to a room. Then, you could use this field as the optional grouping field. This would create the multiple series per room for you.

Michael

Developer Evangelist, Silanis
Re: Gantt chart multiple timeframes per series [message #1007298 is a reply to message #1007218] Tue, 05 February 2013 12:37 Go to previous messageGo to next message
Hauke Luebbers is currently offline Hauke LuebbersFriend
Messages: 4
Registered: November 2012
Junior Member
Ah, if I replace the X-Axis (former String-) value with a number depending on the Hotel room and set the X-Axis type to Linear it works.

Copying this example helped: birt-exchange.org/org/devshare/designing-birt-reports/200-gantt-chart-examples/

Thanks and have a nice day,
Hauke
Re: Gantt chart multiple timeframes per series [message #1007334 is a reply to message #1007298] Tue, 05 February 2013 14:52 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Great! Glad you got it working!

Michael

Developer Evangelist, Silanis
Previous Topic:Where do I put sqljdbc_auth.dll file so that BIRT sees it?
Next Topic:Custom SQL as a parameter
Goto Forum:
  


Current Time: Sat Dec 04 18:12:44 GMT 2021

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

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

Back to the top