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

TreeList Aggregate Specifics

Environment

Product Progress® Kendo UI® TreeList for jQuery

Description

This article explains the specifics about TreeList aggregates and how they are calculated.

Depending on the requirements of your project and the configuration of your data, you can choose between several components to display Aggregates (Calculations or Totals). Some examples are Grid, TreeList and PivotGrid.

The Grid has strong Grouping capabilities: https://demos.telerik.com/kendo-ui/grid/aggregates

And Grid Hierarchy: https://demos.telerik.com/kendo-ui/grid/hierarchy

And also the PivotGrid: https://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding

The same applies for the TreeList, as well. The difference is that in the TreeList all the items should be of the same logical type. Although they can be placed on different levels, all records need to represent the same unit type, for instance - person, order, employee, etc. This component is not suitable for Parent-Child relations. Let's take for instance the following sample: https://dojo.telerik.com/UyEKIcid/6

The Aggregate results are mathematically correct, but logically seem wrong and 1400 "seems" to have been 700 instead. But the results are actually correct and the total should say 1400. This is due to the prerequisite that the TreeList data should not be like Parent-Child or Department-Employee. This is the job of the Grid Grouping. Rather, the TreeList should contain same-type data, like Boss-Employee, where every record's amount/salary/number is its own, and not a total of the inner levels: https://dojo.telerik.com/equROBOr

For better clarification, you can open the following live sample: https://demos.telerik.com/kendo-ui/treelist/aggregates

As a Total count in the TreeList, there are 99 employees. But when you expand the CEO Daryl there are 98 people under him and he himself is the last 99th employee.

Another example you can find here which demonstrates the same thing (different Product's TreeList developed by another team): https://demos.telerik.com/aspnet-ajax/treelist/examples/columns/aggregates/defaultcs.aspx

Where although the Countries seem to be like children of Continents, in the context of records they are all intrepreted as Region Units. Therefore, the total aggregate calculation shows over 10 billion (total of all items) instead of 6.5 billion (total of just parent level).

In this article