Eclipse Community Forums: BIRT » Gantt chart multiple timeframes per series

Home » Archived » BIRT » Gantt chart multiple timeframes per series

Gantt chart multiple timeframes per series [message #1007103]

Mon, 04 February 2013 08:27

Eclipse User

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 00:37

Eclipse User

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.

Re: Gantt chart multiple timeframes per series [message #1007298 is a reply to message #1007218]

Tue, 05 February 2013 07:37

Eclipse User

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 09:52

Eclipse User

Great! Glad you got it working!

Previous Topic:	Where do I put sqljdbc_auth.dll file so that BIRT sees it?
Next Topic:	Custom SQL as a parameter

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Apr 14 17:58:55 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter