Creating reports and dashboards | Stimulsoft community forum

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!

Hello,

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

Thank you.

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!

Hello,

Please see the sample report in attachment.

Thank you.

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!

Hello,

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

Thank you.

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!

Hello,

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

Thank you.

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

Thanks!

Hello,

Please see screenshot in attachment.

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