08-08-2007, 04:51 PM
|
|
|
Re: pie chart dataset problem
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.
>
>
|