| Chart Grouping [message #91101] |
Tue, 15 November 2005 12:18  |
Eclipse User |
|
|
|
Originally posted by: stuart.roe.ovic.co.uk
Guys,
I'm having really problems with trying to group X values on a bar chart.
Can anyone help?
My SQL statement is returning a dataset of 1000 rows. Each row has a field
'type' that has one of three values, 'A', 'B' or 'C'. What I would like is
to have a barchart where the x axis has the categories 'A', 'B' or 'C' and
the y axis being the frequency of the catorgies.
I can do this with an SQL statement, but this is a problem I'm having in a
larger solution I'm working on, hence I'd really like to do this within
BIRT. Can it be done?
|
|
|
| Re: Chart Grouping [message #91130 is a reply to message #91101] |
Tue, 15 November 2005 13:11  |
| Eclipse User |
|
|
|
Hi,
We are working on fixing that, see the bugzilla entry:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=114939
That will allow you to group on the X axis without being restricted to an
interval. For the Y value, you can just use '1' and set the X grouping
aggregation function to 'Sum'.
Thanks,
David
"Stuart Roe" <stuart.roe@ovic.co.uk> wrote in message
news:dld58g$s4q$1@news.eclipse.org...
> Guys,
>
> I'm having really problems with trying to group X values on a bar chart.
> Can anyone help?
>
> My SQL statement is returning a dataset of 1000 rows. Each row has a
> field 'type' that has one of three values, 'A', 'B' or 'C'. What I would
> like is to have a barchart where the x axis has the categories 'A', 'B' or
> 'C' and the y axis being the frequency of the catorgies.
>
> I can do this with an SQL statement, but this is a problem I'm having in a
> larger solution I'm working on, hence I'd really like to do this within
> BIRT. Can it be done?
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.04851 seconds
Home