Multiple bar chart

Hi,
I am new to BIRT and I am struggling adding multiple series to a Bar Chart in MyEclipse Reports which uses BIRT.
Do I need to create a dataset for each series? Or shall I use Filters or Parameters?

Here is the base query I am using for the dataset:

select YEAR, MONTH , SUM(CLIENTS) as "nclients"
from DAILYREGISTRATIONS
group by YEAR, MONTH

and I would like to plot the series in a Bar Chart per YEAR

Thanks for your help
Paolo

Find more posts tagged with

Comments

mwilliams

Hi Paolo,

So, you want month along the x-axis and each year to be a separate bar?

pbassi

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Paolo, 
 
So, you want month along the x-axis and each year to be a separate bar?</blockquote>
 
Exactly! (sorry my post was not very clear...) 
Can you help? 
 
Thanks in advance 
Paolo

mwilliams

Paolo,

On the "Select Data" tab of the chart editor. You should be able to use the Optional Y Series Grouping with your "year" field. This will allow you to put month on the x-axis, the value on the y axis and group by year.

pbassi

<blockquote class='ipsBlockquote' data-author="mwilliams">Paolo, 
 
On the "Select Data" tab of the chart editor. You should be able to use the Optional Y Series Grouping with your "year" field. This will allow you to put month on the x-axis, the value on the y axis and group by year.</blockquote>
 
Thank you Michael, that worked fine! 
 
Paolo

mwilliams

Glad I could help.