| Chart and Aggregates [message #164112] |
Wed, 24 May 2006 10:57  |
Eclipse User |
|
|
|
Originally posted by: em.microcraft.se
Hi,
We are taking our first steps using the Chart functionality in BIRT.
We use a scripted data source. The format looks like this:
ID(String) DATE(String) VALUE(float)
A 050612 100.0
B 060210 120.0
C 050131 130.0
D 060612 30.0
E 050602 110.0
F 060208 150.0
G 050206 30.0
H 060812 30.0
....
From this data set we then group on the first two digits in DATE and
calculate the sum of every year. In this group we group once again on
the third and forth digit in date and calculate the sum for every month
(in the year).
My question is: How can I show these sums visually in a bar chart for
instance? Is it possible, or do I have to precalculate the sums for the
charting?
Best Regards
Erik Mellegård
|
|
|
| Re: Chart and Aggregates [message #165939 is a reply to message #164112] |
Wed, 31 May 2006 12:59  |
| Eclipse User |
|
|
|
Originally posted by: em.microcraft.se
Hi,
I found the answer to my question in the BIRT developer guide
Chapter 15 Working with chart data (I'm sorry for not reading
it before sending the initial question):
> First, you must set up a query that returns data the chart
> can use. Charts do not aggregate data. To use totals in a
> chart, you must create a data set that returns total information
That is, it's not possible to use the calculated values from the
report in a chart, you have to calculate the different sums
before.
Best Regards
Erik
Erik Mellegård wrote:
> Hi,
>
> We are taking our first steps using the Chart functionality in BIRT.
> We use a scripted data source. The format looks like this:
>
> ID(String) DATE(String) VALUE(float)
> A 050612 100.0
> B 060210 120.0
> C 050131 130.0
> D 060612 30.0
> E 050602 110.0
> F 060208 150.0
> G 050206 30.0
> H 060812 30.0
> ...
>
> From this data set we then group on the first two digits in DATE and
> calculate the sum of every year. In this group we group once again on
> the third and forth digit in date and calculate the sum for every month
> (in the year).
>
> My question is: How can I show these sums visually in a bar chart for
> instance? Is it possible, or do I have to precalculate the sums for the
> charting?
>
> Best Regards
>
> Erik Mellegård
|
|
|
Powered by
FUDForum. Page generated in 0.03303 seconds
] 
Search
Help
Register
Login
Home
