Eclipse Community Forums: BIRT » Build an gantt chart: grouping data on Y-axis

Help

Home

Home » Eclipse Projects » BIRT » Build an gantt chart: grouping data on Y-axis

Show: Today's Messages :: Show Polls :: Message Navigator

Build an gantt chart: grouping data on Y-axis [message #729886]

Tue, 27 September 2011 08:18

Missing name Missing name

Messages: 57
Registered: September 2009

Member

Helo,
I have a question about the structure of an XML file to build a Gantt chart.

I use an XML file containing:

<booking>
<reserves startDate="24/8/2011" endDate="9/8/2011" id="1">
    <owns name="Titi" address="Street one"/>
    <concerns>
    	<area>B</area>
    	<capability>4</capability>
    	<name>Red house</name>
    	<roomCount>2</roomCount>
    </concerns>
    
  </reserves>
  <reserves startDate="21/9/2011" endDate="28/9/2011" id="2">
    <owns name="Toto" address="Street two"/>
     <concerns>
    	<area>A</area>
    	<capability>4</capability>
    	<name>Blue house</name>
    	<roomCount>5</roomCount>
    </concerns>
  </reserves>
  <reserves startDate="10/9/2011" endDate="11/9/2011" id="3">
    <owns name="Tutu" address="Street three"/>
     <concerns>
    	<area>A</area>
    	<capability>4</capability>
    	<name>Blue house</name>
    	<roomCount>5</roomCount>
    </concerns>
  </reserves>
</booking>

I would like to create a gantt chart with date in x-axis and area (A,B) in Y-axis.

In the "edit dataset" window in Birt, what Row mapping must I choose ?
/booking/reserves/concerns ?
/booking/reserves/concerns/area ?
/booking/reserves ?

Whatever path, I always have 2 rows for A area and 1 row for B area in the preview result in the Edit dataset window and in my gantt chart I have 2 A and 1 B in y-axis.

I would like to group booking by area in order to have 1 phase for Toto and one phase for Tutu for the A area. Is it possible or must I change the XML file structure ?

Thanks in advance.

Val

Report message to a moderator

Re: Build an gantt chart: grouping data on Y-axis [message #730100 is a reply to message #729886]

Tue, 27 September 2011 15:49

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Val,

What do you want to do with the area b? I am not sure what you want the
resultant chart to look like.

Jason

On 9/27/2011 4:18 AM, val.dupin wrote:
> Helo,
> I have a question about the structure of an XML file to build a Gantt
> chart.
>
> I use an XML file containing:
>
> <booking>
> <reserves startDate="24/8/2011" endDate="9/8/2011" id="1">
> <owns name="Titi" address="Street one"/>
> <concerns>
> <area>B</area>
> <capability>4</capability>
> <name>Red house</name>
> <roomCount>2</roomCount>
> </concerns>
> </reserves>
> <reserves startDate="21/9/2011" endDate="28/9/2011" id="2">
> <owns name="Toto" address="Street two"/>
> <concerns>
> <area>A</area>
> <capability>4</capability>
> <name>Blue house</name>
> <roomCount>5</roomCount>
> </concerns>
> </reserves>
> <reserves startDate="10/9/2011" endDate="11/9/2011" id="3">
> <owns name="Tutu" address="Street three"/>
> <concerns>
> <area>A</area>
> <capability>4</capability>
> <name>Blue house</name>
> <roomCount>5</roomCount>
> </concerns>
> </reserves>
> </booking>
>
>
> I would like to create a gantt chart with date in x-axis and area (A,B)
> in Y-axis.
>
> In the "edit dataset" window in Birt, what Row mapping must I choose ?
> /booking/reserves/concerns ?
> /booking/reserves/concerns/area ?
> /booking/reserves ?
>
> Whatever path, I always have 2 rows for A area and 1 row for B area in
> the preview result in the Edit dataset window and in my gantt chart I
> have 2 A and 1 B in y-axis.
>
> I would like to group booking by area in order to have 1 phase for Toto
> and one phase for Tutu for the A area. Is it possible or must I change
> the XML file structure ?
>
> Thanks in advance.
>
> Val

Report message to a moderator

Re: Build an gantt chart: grouping data on Y-axis [message #730368 is a reply to message #730100]

Wed, 28 September 2011 09:09

Missing name Missing name

Messages: 57
Registered: September 2009

Member

Hello Jason,

Thanks for our reply.
I would like to create a gantt chart to display each booking for each area.
So in the x-axis, there will be placed dates, and in the y-axis, I would like to have area.
Each task represents a reservation( from startdate to enddate).

See the attachment:

index.php/fa/4077/0/

In this image, I only have one task (booking) for each area.

Changing Toto and Tutu start and end dates (on A area), I realised that Tutu booking and Toto booking using A area are glued. The chart considers that the task is from Tutu booking startdate to Toto booking enddate. Why ?

I attach the rptdesign and xml data files too, that create this gantt chart.

Thanks in advance.

Val.

Attachment: gantt.jpeg
(Size: 6.92KB, Downloaded 768 times)
Attachment: report.rptdesign
(Size: 49.58KB, Downloaded 197 times)
Attachment: booking.xml
(Size: 0.79KB, Downloaded 130 times)

[Updated on: Wed, 28 September 2011 09:20]

Report message to a moderator

Re: Build an gantt chart: grouping data on Y-axis [message #730435 is a reply to message #730368]

Wed, 28 September 2011 12:00

Missing name Missing name

Messages: 57
Registered: September 2009

Member

I found the solution Very Happy

:

I create a Data Cube with 2 groups (areaGroup based on area field and ownerGroup based on area field), and I added startDate, enddate and OwnerName in summary fields.

Then, in the gantt chart, I use this data cube. I placed startDate and endDate in the value Y series, and areaGroup in Category x Serie. I filled the Optionnal Y serie grouping with the second group ownerGroup.

That's OK.

This can help someone else !

Thanks Jason.

Report message to a moderator

Re: Build an gantt chart: grouping data on Y-axis [message #730537 is a reply to message #730368]

Wed, 28 September 2011 15:14

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Val,

Take a look at the attached example that uses your data. Notice I added
two computed columns for the dates.

Jason

On 9/28/2011 5:09 AM, val.dupin wrote:
> Hello Jason,
>
> Thanks for our reply.
> I would like to create a gantt chart to display each booking for each area.
> So in the x-axis, there will be placed dates, and in the y-axis, I would like to have area.
> Each task represents a reservation( from startdate to enddate).
>
> See the attachment:
>
>
>
> In this image, I only have one task (booking) for each area. Tutu booking doesn't appear. Why ?
>
> I attach the rptdesign and xml data files too, that create this gantt chart.
>
> Thanks in advance.
>
> Val.

Attachment: gantt.zip
(Size: 5.13KB, Downloaded 178 times)

Report message to a moderator

Previous Topic:	Deploying on Linux with Oracle
Next Topic:	Chart scripting with report variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 22 12:51:31 GMT 2017

.:: Contact :: Home ::.