pie chart dataset problem

Hi all,

I just started exploring BIRT and its features last week. I studied the
example demo carefully and decided to do a little pilot report for our
business.

For this example, I created an sql database daily_stats with the following
colums in it: date (date data type)bad_recipient, rate_control, spam,
quarantine, tagged and allowed.

this database holds records about daily spam stats.

I'm now able to generate a :
* table which lists all the colums for a given month
* graphs which list a trend for a given column in time (the date column)

what I now miss/fail to create is:
* a pie chart showing me the percentages of each "monthly spam score
total". I created another data set which returns the sum of each column
except the date column. this gives you a data set like this:

|rate_control|spam|allowed|...
|sum(rate_control)|sum(spam)|sum(allowed)|...

which is not useful as a data set to create a pie chart because it expects
something like this (remember the car example on the website):
|kind of spam score|it's months total|
|spam|sum(spam)|
|allowed|sum(allowed)|
|rate_control|sum(rate_control)|


I think my database design is pretty common/simple so I feel that I'm
missing the point somewhere along the road...

thanks for your advice!

kind regards,

Maarten.

join this request: https://bugs.eclipse.org/bugs/show_bug.cgi?id=162528

Maarten Claes napsal(a):
> Hi all,
>
> I just started exploring BIRT and its features last week. I studied the
> example demo carefully and decided to do a little pilot report for our
> business.
>
> For this example, I created an sql database daily_stats with the
> following colums in it: date (date data type)bad_recipient,
> rate_control, spam, quarantine, tagged and allowed.
>
> this database holds records about daily spam stats.
>
> I'm now able to generate a :
> * table which lists all the colums for a given month
> * graphs which list a trend for a given column in time (the date column)
>
> what I now miss/fail to create is:
> * a pie chart showing me the percentages of each "monthly spam score
> total". I created another data set which returns the sum of each column
> except the date column. this gives you a data set like this:
>
> |rate_control|spam|allowed|...
> |sum(rate_control)|sum(spam)|sum(allowed)|...
>
> which is not useful as a data set to create a pie chart because it
> expects something like this (remember the car example on the website):
> |kind of spam score|it's months total|
> |spam|sum(spam)|
> |allowed|sum(allowed)|
> |rate_control|sum(rate_control)|
>
>
> I think my database design is pretty common/simple so I feel that I'm
> missing the point somewhere along the road...
>
> thanks for your advice!
>
> kind regards,
>
> Maarten.
>
>