Home » Archived » BIRT » charting problem
charting problem [message #155241] |
Fri, 21 April 2006 13:53 |
imre farkas Messages: 26 Registered: July 2009 |
Junior Member |
|
|
Hi,
I have a question about charting:
I have a csv datasource:
Type,Amount,Currency
STRING,DOUBLE,STRING
A,10000,EUR
B,500,EUR
C,400,USD
A,300,USD
C,800,EUR
B,600,EUR
I create a table with groupping by Type (type is the first column) and
the second column is Total.sum(row["amount"], row["Currency"] == "EUR")
and I have not got details row.
The result is fine:
Type EUR
A 10000
B 1100
C 800
I want to create a pie chart where the slices are A, B and C and values
are A = 10000, B = 1100, C = 800 but I have not been able to do this.
It maybe not possible in birt...
thx in advance
-farkas
ps: I currently use Birt 2.0.1
|
|
|
Re: charting problem [message #155459 is a reply to message #155241] |
Sat, 22 April 2006 07:17 |
David Michonneau Messages: 1145 Registered: July 2009 |
Senior Member |
|
|
Hi,
You can set a filter on the chart to filter out the USD values. Then you can
group in the chart by Type (category Series/Group, choose Text, interval set
to 0, aggregate=sum). This should work
Thanks,
David
"farkas" <farkas.imre@chello.hu> wrote in message
news:e2ao46$jmd$1@utils.eclipse.org...
> Hi,
>
> I have a question about charting:
>
> I have a csv datasource:
>
> Type,Amount,Currency
> STRING,DOUBLE,STRING
> A,10000,EUR
> B,500,EUR
> C,400,USD
> A,300,USD
> C,800,EUR
> B,600,EUR
>
> I create a table with groupping by Type (type is the first column) and the
> second column is Total.sum(row["amount"], row["Currency"] == "EUR") and I
> have not got details row.
>
> The result is fine:
> Type EUR
> A 10000
> B 1100
> C 800
>
> I want to create a pie chart where the slices are A, B and C and values
> are A = 10000, B = 1100, C = 800 but I have not been able to do this.
>
> It maybe not possible in birt...
>
> thx in advance
> -farkas
>
> ps: I currently use Birt 2.0.1
>
|
|
|
Re: charting problem [message #155471 is a reply to message #155459] |
Sat, 22 April 2006 15:22 |
imre farkas Messages: 26 Registered: July 2009 |
Junior Member |
|
|
David Michonneau írta:
> Hi,
>
> You can set a filter on the chart to filter out the USD values. Then you can
> group in the chart by Type (category Series/Group, choose Text, interval set
> to 0, aggregate=sum). This should work
>
> Thanks,
>
> David
>
> "farkas" <farkas.imre@chello.hu> wrote in message
> news:e2ao46$jmd$1@utils.eclipse.org...
>> Hi,
>>
>> I have a question about charting:
>>
>> I have a csv datasource:
>>
>> Type,Amount,Currency
>> STRING,DOUBLE,STRING
>> A,10000,EUR
>> B,500,EUR
>> C,400,USD
>> A,300,USD
>> C,800,EUR
>> B,600,EUR
>>
>> I create a table with groupping by Type (type is the first column) and the
>> second column is Total.sum(row["amount"], row["Currency"] == "EUR") and I
>> have not got details row.
>>
>> The result is fine:
>> Type EUR
>> A 10000
>> B 1100
>> C 800
>>
>> I want to create a pie chart where the slices are A, B and C and values
>> are A = 10000, B = 1100, C = 800 but I have not been able to do this.
>>
>> It maybe not possible in birt...
>>
>> thx in advance
>> -farkas
>>
>> ps: I currently use Birt 2.0.1
>>
>
>
thanks a lot. it works. great.
regards
-farkas
|
|
|
Goto Forum:
Current Time: Thu Oct 03 02:35:47 GMT 2024
Powered by FUDForum. Page generated in 0.05896 seconds
|