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

Count rows on data grid

1 Answer 151 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jeffrey
Top achievements
Rank 1
Jeffrey asked on 08 Jun 2017, 12:44 PM

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.

1 Answer, 1 is accepted

Sort by
0
Georgi
Telerik team
answered on 09 Jun 2017, 02:08 PM
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.
Tags
Grid
Asked by
Jeffrey
Top achievements
Rank 1
Answers by
Georgi
Telerik team
Share this question
or