Aggregates

To make aggregates available on the client, configure them in the DataSourceAggregatesFactory. by using the ToDataSourceResult() extension method on the server, the results will be sent in the response object and can be used in group headers, footers or other client-side templates.

• The Aggregates method sets the aggregates.

    @(Html.Kendo().DataSource<ProductViewModel>()
        .Name("dataSource1")
        .Ajax(dataSource => dataSource
            .PageSize(10)
            .Read(read => read.Action("Products_Read", "Home"))
            .Aggregates(aggregates =>
            {
                aggregates.Add(product => product.UnitsInStock).Min().Max().Count();
                aggregates.Add(product => product.UnitsOnOrder).Average();
                aggregates.Add(product => product.ProductName).Count();
                aggregates.Add(product => product.UnitPrice).Sum();
            })
        )
    )

    <kendo-datasource name="dataSource1" type="DataSourceTagHelperType.Ajax" page-size="10">
        <transport>
            <read url="@Url.Action("Products_Read", "Home")" />
        </transport>
        <aggregates>
            <aggregate field="UnitsInStock" aggregate="min,max,count" />
            <aggregate field="UnitsOnOrder" aggregate="average"/>
            <aggregate field="ProductName" aggregate="count"/>
            <aggregate field="UnitPrice" aggregate="sum"/>
        </aggregates>
    </kendo-datasource>

See Also

• Server-Side API