[venkatmadh]

hi


i am very new birt tool


I want render my data in bar chart, my problem I need to display multiple x-axes because of monthly reports (year wise)

can any one guide me one this

i am attaching my data please give me some suggesition to draw a graph


Advanced Thanks

Attached File(s)

•  birt Report.png (51.35K)
  Number of downloads: 0

[RichT]

Hi,

There's probably a few ways to do this but based on your example data set, I was thinking if you ungroup your count type you can regroup it in the chart. Maybe something like this:

Address          Month          Qty        Type
91343...         1/1/2010       56         Submitted
91343...         1/1/2010       46         Forward
91343...         1/1/2010       36         Forward Fail
91344...         3/1/2010       66         Submitted
91344...         3/1/2010       54         Forward
91344...         3/1/2010       66         Forward Fail
91355...         2/1/2010       45         Submitted
91355...         2/1/2010       54         Forward
91355...         2/1/2010       43         Forward Fail
etc.

From there if you assign your y-series grouping as the Address, I think BIRT will further break the Addresses Type into the chart. Either the stacked or side-by-side charts should work for you depending on how you want to display this data.

Depending on how your data is provided to you this ungrouping may not be a solution for you but hopefully this suggestion will help out.

Let me know,
Rich

[venkatmadh]

RichT, on 11 April 2012 - 05:21 PM, said:

Hi,

There's probably a few ways to do this but based on your example data set, I was thinking if you ungroup your count type you can regroup it in the chart. Maybe something like this:

Address          Month          Qty        Type
91343...         1/1/2010       56         Submitted
91343...         1/1/2010       46         Forward
91343...         1/1/2010       36         Forward Fail
91344...         3/1/2010       66         Submitted
91344...         3/1/2010       54         Forward
91344...         3/1/2010       66         Forward Fail
91355...         2/1/2010       45         Submitted
91355...         2/1/2010       54         Forward
91355...         2/1/2010       43         Forward Fail
etc.

From there if you assign your y-series grouping as the Address, I think BIRT will further break the Addresses Type into the chart. Either the stacked or side-by-side charts should work for you depending on how you want to display this data.

Depending on how your data is provided to you this ungrouping may not be a solution for you but hopefully this suggestion will help out.

Let me know,
Rich

hi

rich


thanks for your support

But
could draw bar chart to my data, why be i am unable to understand your scenario



Thank you

[RichT]

Hi,

Will the GT address have only one month associated with it like in the example you provided?

Thanks,
Rich

[venkatmadh]

RichT, on 13 April 2012 - 08:57 AM, said:

Hi,

Will the GT address have only one month associated with it like in the example you provided?

Thanks,
Rich

hi

rich thanks for quick response

it may contain multiple entries ( months ) for each GT Address

[RichT]

Hi,

I wasn't able to come up with a good way to depict a chart needing 2 x-axis categories but I have attached a report containing 2 alternatives. 'Example 1' produces a chart for each Address and 'Example 2' produces a chart by month that does not break out Address and just sums the Submittal Type by month.

There might be a way to produce a 3D version of the report to support both Month and Address but I couldn't figure it out.

Hope it helps,
Rich

BIRT 2.6.2

Attached File(s)

•  new_report_12.zip (8.2K)
  Number of downloads: 3