jube-fork/Jube.App/wwwroot/kendo/examples/grid/aggregates.html

<!DOCTYPE html>
<html>
<head>
    <title>Aggregates</title>
    <meta charset="utf-8">
    <link href="../content/shared/styles/examples-offline.css" rel="stylesheet">
    <link href="../../styles/kendo.common.min.css" rel="stylesheet">
    <link href="../../styles/kendo.rtl.min.css" rel="stylesheet">
    <link href="../../styles/kendo.default.min.css" rel="stylesheet">
    <link href="../../styles/kendo.default.mobile.min.css" rel="stylesheet">
    <script src="../../js/jquery.min.js"></script>
    <script src="../../js/jszip.min.js"></script>
    <script src="../../js/kendo.all.min.js"></script>
    <script src="../content/shared/js/console.js"></script>
    <script>
        
    </script>
    
    
</head>
<body>
    
        <a class="offline-button" href="../index.html">Back</a>
    
    
<div id="example">
    <div id="grid"></div>
    <script>
        $(document).ready(function() {
            $("#grid").kendoGrid({
                dataSource: {
                    type: "odata",
                    transport: {
                        read: "https://demos.telerik.com/kendo-ui/service/Northwind.svc/Products"
                    },
                    schema:{
                        model: {
                            fields: {
                                UnitsInStock: { type: "number" },
                                ProductName: { type: "string" },
                                UnitPrice: { type: "number" },
                                UnitsOnOrder: { type: "number" },
                                UnitsInStock: { type: "number" }
                            }
                        }
                    },
                    pageSize: 7,
                    group: {
                                field: "UnitsInStock", aggregates: [
                                { field: "ProductName", aggregate: "count" },
                                { field: "UnitPrice", aggregate: "sum"},
                                { field: "UnitsOnOrder", aggregate: "average" },
                                { field: "UnitsInStock", aggregate: "count" }
                                ]
                            },

                    aggregate: [ { field: "ProductName", aggregate: "count" },
                                    { field: "UnitPrice", aggregate: "sum" },
                                    { field: "UnitsOnOrder", aggregate: "average" },
                                    { field: "UnitsInStock", aggregate: "min" },
                                    { field: "UnitsInStock", aggregate: "max" }]
                },
                sortable: true,
                scrollable: false,
                pageable: true,
                columns: [
                    { field: "ProductName", title: "Product Name", aggregates: ["count"], footerTemplate: "Total Count: #=count#", groupFooterTemplate: "Count: #=count#" },
                    { field: "UnitPrice", title: "Unit Price", aggregates: ["sum"], groupHeaderColumnTemplate: "Sum: #=sum#" },
                    { field: "UnitsOnOrder", title: "Units On Order", aggregates: ["average"], footerTemplate: "Average: #=average#",
                        groupFooterTemplate: "Average: #=average#" },
                    { field: "UnitsInStock", title: "Units In Stock", aggregates: ["min", "max", "count"], footerTemplate: "<div>Min: #= min #</div><div>Max: #= max #</div>",
                        groupHeaderTemplate: "Units In Stock: #= value # (Count: #= count#)" }
                ]
            });
        });
    </script>
</div>


    
</body>
</html>