Eclipse Community Forums: BIRT » pie chart

Home » Archived » BIRT » pie chart - groupin

Thu, 23 June 2005 21:10

Eclipse User

Originally posted by: junaili.gmail.com

Hi,
I have the following data:
cat val
--- ---
cat1 val1
cat1 val2
....
cat2 val1
cat2 val2
....
cat3 val3
....

I want to be able to create a pie chart for
cat count()
--- ----
cat1 45
cat2 32
cat3 92
cat4 1
cat5 3

The pie chart will have all count() >10 as part of the pieces. All the
other cat(s) that have count()<10 will be combined into something like
cat-other, and the count() will be the sum of count() of those cat (that
are less than 10).
Is this currently supported?

Any pointer will be much appreciated.
Thank you!

Re: pie chart - groupin [message #51245 is a reply to message #51022]

Fri, 24 June 2005 09:51

Eclipse User

Originally posted by: none.none.com

This is a multi-part message in MIME format.

------=_NextPart_000_014C_01C578D4.90A66130
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

The pie chart itself does not have this "min slice" feature, but you can =
achieve the same result using a dataset defined by the following SQL =
query:

select cat, sum (val) as sumval
from Table1

group by cat

having sum(val)>10

union

select 'others' as cat, sum (val) as sumval

from Table1 where cat in ( select cat from Table1

group by cat

having sum(val)<=3D10

)

group by 'others'

Then, just bind this dataset to the pie chart.

Thanks,

David

"J L" <junaili@gmail.com> wrote in message =
news:d9fmjf$ve$1@news.eclipse.org...
> Hi,
> I have the following data:
> cat val
> --- ---
> cat1 val1
> cat1 val2
> ...
> cat2 val1
> cat2 val2
> ...
> cat3 val3
> ...
>=20
> I want to be able to create a pie chart for
> cat count()
> --- ----
> cat1 45
> cat2 32
> cat3 92
> cat4 1
> cat5 3
>=20
> The pie chart will have all count() >10 as part of the pieces. All the =

> other cat(s) that have count()<10 will be combined into something like =

> cat-other, and the count() will be the sum of count() of those cat =
(that=20
> are less than 10).
> Is this currently supported?
>=20
> Any pointer will be much appreciated.
> Thank you!
------=_NextPart_000_014C_01C578D4.90A66130
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2668" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>The pie chart itself does not have this "min slice" =
feature, but you=20
can achieve the same result using a dataset defined by the following SQL =

query:</DIV>
<DIV> </DIV>
<DIV>select cat,=20
sum (val)=20
as sumval</DIV>
<DIV>
from Table1
group by cat
having sum(val)>10<FONT=20
color=3D#7f0055 size=3D2>
union
select 'others'=20
as cat,=20
sum (val)=20
as <FONT=20
size=3D2>sumval
from Table1 where cat in=20
( select=20
cat from=20
Table1
group by cat
having sum(val)<=3D10
)
group by 'others'</DIV>
<DIV> </DIV>
<DIV>Then, just bind this dataset to the pie chart.</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV> </DIV>
<DIV>David</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"J L" <<A =
href=3D"mailto:junaili@gmail.com">junaili@gmail.com</A>>=20
wrote in message <A=20
href=3D"news:d9fmjf$ve$1@news.eclipse.org">news:d9fmjf$ve$1@news.eclipse.=
org</A>...</DIV>>=20
Hi, > I have the following data: > cat val > --- =
--- >=20
cat1 val1 > cat1 val2 > ... > cat2 val1 > cat2=20
val2 > ... > cat3 val3 > ... > > I want =
to be=20
able to create a pie chart for > cat count() > --- =
---- > cat1=20
45 > cat2 32 > cat3 92 > cat4 1 > cat5 3 > =

 > The pie chart will have all count() >10 as part of the =
pieces. All=20
the > other cat(s) that have count()<10 will be combined into=20
something like > cat-other, and the count() will be the sum of =
count() of=20
those cat (that > are less than 10). > Is this currently=20
supported? > > Any pointer will be much =
appreciated. > Thank=20
you!</BODY></HTML>

------=_NextPart_000_014C_01C578D4.90A66130--

Previous Topic:	Hiding Border
Next Topic:	Chart Error

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 08:32:24 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter