nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bar chart of Birt

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

Find more posts tagged with

Comments

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: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>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.</pre>
 
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

<blockquote class='ipsBlockquote' data-author="'RichT'" data-cid="98866" data-time="1334193674" data-date="11 April 2012 - 06:21 PM">
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: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>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.</pre>
 
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 </blockquote>
 
 
 
 
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

<blockquote class='ipsBlockquote' data-author="'RichT'" data-cid="98962" data-time="1334336221" data-date="13 April 2012 - 09:57 AM">
Hi, 
 
Will the GT address have only one month associated with it like in the example you provided? 
 
Thanks, 
Rich </blockquote>
 
 
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