New to Kendo UI for jQuery? Download free 30-day trial

jQuery Grid Selection Aggregates

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Kendo UI Dojo
Change Theme
default
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Ocean Blue A11Y

Purple

Turquoise
Bootstrap Theme

Main

Bootstrap 3

Bootstrap 3 Dark

Main Dark

Nordic

Turquoise

Turquoise Dark

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Green

Green Dark

Lavender

Lavender Dark

Main Dark

Metro

Metro Dark

Moonlight

Opal

Opal Dark

Silver

Silver Dark

Uniform
Fluent Theme

Main
Launch Theme Builder

                        selection-aggregates.html
                    
                        Sample service

Also available for:

API REFERENCE

Displaying Selection Aggregates in Status BarDisplaying Selection Aggregates Externally <button id="display-aggregates" type="button">Display Aggregates</button> $(document).ready(function() { $("#status-bar-aggregates").kendoGrid({ dataSource: { data: products, schema: { model: { fields: { ProductName: { type: "string" }, UnitPrice: { type: "number" }, UnitsInStock: { type: "number" }, Discontinued: { type: "boolean" } } } }, pageSize: 15 }, height: 550, persistSelection: true, selectable: { mode: "multiple cell", cellAggregates: true }, statusBarTemplate: ({ aggregates }) => { var result = ""; for (const aggregate in aggregates) { const value = aggregates[aggregate]; if (value || value === 0) { result += `<div class="k-selection-aggregates-item"><span class="k-selection-aggregates-item-text">${aggregate}: </span><span class="k-selection-aggregates-item-value">${formatAggregate(aggregates[aggregate], aggregate)}</span></div>`; } } return result; }, scrollable: true, columns: [ { field: "ProductName", title: "Product Name" }, { field: "UnitsInStock", title: "Units In Stock", format: "{0:MM/dd/yyyy}", width: "150px" }, { field: "Discontinued", title: "Discontinued", template: discTemplate, attributes: { class: "k-text-center !k-justify-content-center" }, width: "130px" }, { field: "UnitPrice", title: "Unit Price", width: "150px" } ] }); let aggregates; $("#external-aggregates").kendoGrid({ dataSource: { data: products, schema: { model: { fields: { ProductName: { type: "string" }, UnitPrice: { type: "number" }, UnitsInStock: { type: "number" }, Discontinued: { type: "boolean" } } } }, pageSize: 15 }, toolbar: [ { template: kendo.template($("#toolbar-template").html()) } ], height: 550, persistSelection: true, selectable: { mode: "multiple cell", cellAggregates: true }, scrollable: true, columns: [ { field: "ProductName", title: "Product Name" }, { field: "UnitsInStock", title: "Units In Stock", format: "{0:MM/dd/yyyy}", width: "150px" }, { field: "Discontinued", title: "Discontinued", template: discTemplate, attributes: { class: "k-text-center !k-justify-content-center" }, width: "130px" }, { field: "UnitPrice", title: "Unit Price", width: "150px" } ], change: function(e) { displayAggregatesBttn.enable(true); aggregates = e.cellAggregates; } }); function aggregatesTemplate(aggregates) { var result = '<div class="k-d-flex k-gap-sm">'; for (const aggregate in aggregates) { const value = aggregates[aggregate]; if (value || value === 0) { result += `<div class="k-selection-aggregates-item"><span class="k-selection-aggregates-item-text">${aggregate}: </span><span class="k-selection-aggregates-item-value">${formatAggregate(aggregates[aggregate], aggregate)}</span></div>`; } } result += '</div>'; return result; } let displayAggregatesBttn = $("#display-aggregates").kendoButton({ enable: false, click: function() { let dialogContent = aggregatesTemplate(aggregates); let aggregatesDialog = $("#aggregates-dialog").kendoDialog({ title: "Selection Aggregates", content: dialogContent, actions: [{ text: "Close", primary: true }], width: 550, minWidth: 250 }).data("kendoDialog"); aggregatesDialog.open(); } }).data("kendoButton"); kendo.ui.icon($(".check"), { icon: 'k-i-check' }); kendo.ui.icon($(".x-icon"), { icon: 'k-i-x' }); }); function formatAggregate(aggregate, key) { if (key === "average" || key === "sum" || key === "max" || key === "min") { return kendo.toString(aggregate, "n"); } if (key === "earliest" || key === "latest") { return kendo.toString(aggregate, "dd/MM/yyyy"); } return aggregate; } function discTemplate(data) { return data.Discontinued ? "<span class='k-icon check'></span>" : "<span class='k-icon x-icon'></span>"; }

Description

The Kendo UI for jQuery Grid allows the users to get a quick snapshot of some of the more important aggregates of the selected data. You can use the built-in approach and display these metrics in the status bar at the bottom of the Grid or create your own elements that would display the data.

This demo showcases two Grid selection aggregate configurations. The first Grid displays the selection aggregates in a status bar by using the statusBarTemplate property. The second Grid displays the selection aggregates externally in a jQuery Dialog.

This Grid example is part of a unique collection of hundreds of jQuery demos, with which you can see all Kendo UI for jQuery components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in Kendo UI for jQuery Dojo or ThemeBuilder.

jQuery Grid Selection Aggregates

Description

Support & Learning Resources

Additional Resources

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

jQuery Grid Selection Aggregates

Description

Support & Learning Resources

Additional Resources