Pie Charts

[jay@bplogix.com]

I am having a hard time setting up a simple pie chart. I have a DataSource that looks like this:
Name Amount
==== ======
Bob 100
Bob 200
Sue 50
Tom 150
Tom 150
Tom 200

How do I set up a pie chart the shows the total (sum of "Amount") for each "Name"?
How do I set up a pie chart the shows the count (count of "Name") for each "Name"?

Thanks!

[Alex K.]

Hello,

You can use "Data from Other DataSource" with necessary grouping.
Please see the sample report in attachment.

Thank you.

[jay@bplogix.com]

Great, thanks!

Is it neccessary to use the "Data from Other DataSource" if my table looks like this:
Col1 Col2 Col3
=== === ===
10 40 70
20 50 80
30 60 90

If I wanted a pie chart that showed the average (or count or sum) of Col1, Col2, Col3, do I have to use "Data from Other DataSource" to average the numbers ... or are there built-in functions to average/total/count the entries in the row? I am hoping I could place the chart in the data header or footer and use something like Totals.Avg(Col1) but I keep getting errors running the report.

Thanks!

[Alex K.]

Hello,

Please see the sample report in attachment.

Thank you.

[jay@bplogix.com]

Thank you for the sample. That was a good sample for my first question ... where one column had a name and another had an amount and you want to group by totals by the name value.

But what if I want to graph a total of an entire column (not grouped)? Do I still need to use "Data from Other DataSource" or is there a way to chart a total of an enture column with just a formula or something?

Col1 Col2
=== ===
10 40
20 50
30 60

For example, with the above data have a pie chart that has one slice of 60 (the total of Col1) ... and the other slice 150 (the total of Col2)? Does this require a "Data from Other DataSource"?

Thanks!

[Alex K.]

Hello,

As a way, you can use the variables.
Please see the sample report in attachment.

Thank you.

[jay@bplogix.com]

Thanks. That does exactly what I was looking for ... but I cannot see how the variables work? How are the configured to hold the total of those columns? Is there a setting somewhere that has a formula? The properties for the SumCol1 and SumCol3 variables just show a default value of 0.

Thanks!

[Alex K.]

Hello,

Variables SumCol1 and SumCol2 calculated in After Print event of databand component.

Thank you.

[jay@bplogix.com]

I am sorry for so many questions ... but how do I edit/see the events (such as After Print) in the report?

Thanks!

[Alex K.]

Hello,

Please see screenshot in attachment.

Let us know if you need any additional help.
Thank you.