How to SUM the results of a column.

2 posts, 0 answers
  1. Balen
    Balen avatar
    5 posts
    Member since:
    Oct 2018

    Posted 05 Dec 2019 Link to this post

    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

     

     

  2. Neli
    Admin
    Neli avatar
    255 posts

    Posted 10 Dec 2019 Link to this post

    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
Back to Top