New to Telerik UI for ASP.NET Core? Download free 30-day trial

Aggregates

Loading Demo...

EXAMPLE
VIEW SOURCE
EDIT IN TELERIK REPL
- Edit in Telerik REPL
- Edit in Theme Builder
Change Theme
default
Themes & Swatches

SASS

LESS

Launch Theme Builder
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Purple

Turquoise
Bootstrap Theme

Main

Main Dark

Nordic

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Main Dark

Opal

Silver
- Black
- Blue Opal
- Bootstrap v3
- Default
- Fiori
- Flat
- High Contrast
- Material
- Material Black
- Metro
- Metro Black
- Moonlight
- Nova
- Office 365
- Silver
- Uniform

                    aggregates.cshtml
                
                    AggregatesController.cs
                
                    EmployeeDirectoryController.cs
                
                    EmployeeDirectoryModel.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

kendo.syncReady(function(){jQuery("#treelist").kendoTreeList({"columns":[{"field":"FirstName","footerTemplate":"#= count # employee(s)","template":"#: FirstName # #: LastName #","title":"Name","filterable":true},{"field":"Position","filterable":true},{"field":"HireDate","footerTemplate":"Last employee hired on #= kendo.format(\u0027{0:MMMM d, yyyy}\u0027, kendo.parseDate(max)) #","format":"{0:MMMM d, yyyy}","title":"Hire Date","filterable":true}],"filterable":true,"height":540,"sortable":true,"dataSource":{"type":(function(){if(kendo.data.transports['aspnetmvc-ajax']){return 'aspnetmvc-ajax';} else{throw new Error('The kendo.aspnetmvc.min.js script is not included.');}})(),"transport":{"read":{"url":"/aspnet-core/employeedirectory/all"},"prefix":""},"aggregate":[{"field":"FirstName","aggregate":"count"},{"field":"HireDate","aggregate":"max"}],"schema":{"data":"Data","total":"Total","errors":"Errors","model":{"id":"EmployeeId","parentId":"ReportsTo","fields":{"EmployeeId":{"nullable":false,"type":"number"},"FirstName":{"nullable":false,"type":"string"},"LastName":{"nullable":false,"type":"string"},"ReportsTo":{"nullable":true,"type":"number","defaultValue":null},"Address":{"nullable":false,"type":"string"},"City":{"nullable":false,"type":"string"},"Country":{"nullable":false,"type":"string"},"Phone":{"nullable":false,"type":"string"},"Extension":{"nullable":false,"type":"number","defaultValue":null},"Position":{"nullable":false,"type":"string"},"BirthDate":{"nullable":false,"type":"date","defaultValue":null},"hasChildren":{"nullable":false,"type":"boolean"},"HireDate":{"nullable":false,"type":"date","defaultValue":null},"CountryFlag":{"nullable":false,"type":"string"}}}}}});});

Description

The TreeList comes with an option to display aggregated number results when data is grouped. The aggregated result can be displayed in a group header, footer, or the summary footer of the component.

You can enable grouping with aggregates by using the methods DataSource.Aggregates(), ClientGroupFooterTemplate(), ClientGroupHeaderColumnTemplate(), or ClientFooterTemplate(), and the aggregate fields of the TreeList’s data source aggr.Add(e => e.FirstName).Count().

Aggregates

Themes & Swatches

Description

Support & Learning Resources