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
0
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
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.