Eclipse Community Forums: BIRT » basic chart and XML data

Home » Archived » BIRT » basic chart and XML data

basic chart and XML data [message #243411]

Tue, 19 June 2007 16:50

Eclipse User

Originally posted by: irbull.cs.uvic.ca

I am trying to make a very basic chart. I have an XML data source:

<item>Eclipse</item>
<item>Eclipse</item>
<item>Eclipse</item>
<item>Eclipse</item>
<item>Eclipse</item>
<item>Net Beans</item>
<item>Net Beans</item>
<item>Net Beans</item>
<item>Net Beans</item>
<item>Visual Studio</item>
<item>Visual Studio</item>
<item>Visual Studio</item>

and I would like to make a chart to show the number of users in each
category. When I create my XML datasource I get 1 column with all these
values. From what I have read, I cannot do this type of aggregation at
the chart level (most people suggest using an SQL query but that doesn't
work with an XML data source).

Any advice?

Cheers,
Ian

Re: basic chart and XML data [message #243994 is a reply to message #243411]

Thu, 21 June 2007 11:45

Eclipse User

Bind your category series to this unique column that you have. Set a
grouping on the category series, use count as an aggregate (or sum can work
too). Put 1 on the y value series. It should work.

Thanks,

David

"Ian Bull" <irbull@cs.uvic.ca> wrote in message
news:f59fmd$hn5$1@build.eclipse.org...
>I am trying to make a very basic chart. I have an XML data source:
>
> <item>Eclipse</item>
> <item>Eclipse</item>
> <item>Eclipse</item>
> <item>Eclipse</item>
> <item>Eclipse</item>
> <item>Net Beans</item>
> <item>Net Beans</item>
> <item>Net Beans</item>
> <item>Net Beans</item>
> <item>Visual Studio</item>
> <item>Visual Studio</item>
> <item>Visual Studio</item>
>
> and I would like to make a chart to show the number of users in each
> category. When I create my XML datasource I get 1 column with all these
> values. From what I have read, I cannot do this type of aggregation at
> the chart level (most people suggest using an SQL query but that doesn't
> work with an XML data source).
>
> Any advice?
>
> Cheers,
> Ian

Previous Topic:	Problem with Tooltips display on SVG Charts
Next Topic:	Markers in datetime axes

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 17:58:08 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter