Count rows on data grid

2 posts, 0 answers
  1. Jeffrey
    Jeffrey avatar
    1 posts
    Member since:
    May 2017

    Posted 08 Jun 2017 Link to this post

    Hi,

    I'm new to Kendo, but have came across a fairly complex issue.  I'm trying to create a view of data, that counts the number of deals made in each quarter.  The data is structured as shown in the attached image (see data.png).  I've also attached a mockup of the format I want to get this data into (see outcome.png).

    What I think it needs to do is count the rows that match a specific 'Customer type' and 'Quarter' and then display this in a new column alongside the customer type.

     

    Is this something that's possible with Kendo?  If so, how would I go about making a start on this?

    Kind regards,

    Jeff.

  2. Georgi
    Admin
    Georgi avatar
    671 posts

    Posted 09 Jun 2017 Link to this post

    Hello Jeffrey,

    The functionality you describe is not available out of the box for the Grid component. If you would like to display the data in such a way you should perform the necessary grouping and modifications on the server and then pass the data to the Grid. 

    Furthermore if you want to work with aggregated data you can consider using Pivot Grid. It allows the user to perform complex analysis on the visualized data. Also supports a drill-down functionality that represents the underlying data for calculated cells.


    Regards,
    Georgi
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top