This is a migrated thread and some comments may be shown as answers.

How to SUM the results of a column.

1 Answer 244 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Balen
Top achievements
Rank 1
Balen asked on 05 Dec 2019, 03:04 PM

HI Guys,

 

I am new to telerik report designer, i have trying to create a report that consists of 3 sections.

Section 1 is a summary of a team, section 2 is the average of staff, and staff stats.

I am having difficulty with the average row as i need to sum the values of each agents "Calls to Success" stats and divided by the number of agent which is 3.

So i should be getting 5.14.

 

Any idea guys.

 

Thanks

 

 

1 Answer, 1 is accepted

Sort by
1
Neli
Telerik team
answered on 10 Dec 2019, 07:44 AM

Hello Balen,

You can use the approach applied in the attached report:

1. Add a CSV DataSource with Name and CallToSuccess columns;

2. Display the data in a Table item;

3. Right-click over the table -> Insert row - > Outside group - Below

4. In the new row, use the Aggregate function AVG:

= Avg(Fields.CallsToSuccess)

Because you mentioned that you are new to Telerik Repoting, I am sending you our First steps articles that demonstrate how to create, set up, and publish a sample Demo report.

Creating the Demo report

Setting the page header

Populating the table with data

Creating the graph

Setting the page footer

Integrating the report in Visual Studio Application

Parameterizing the graph

Adding the column graph

 

Regards,
Neli
Progress Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Augusto
Top achievements
Rank 1
commented on 19 Aug 2021, 04:11 AM

Excelent!! it works for me... thanks a lot!
Tags
General Discussions
Asked by
Balen
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or