New to Telerik UI for Xamarin? Download free 30-day trial

PropertyAggregateDescriptor

The PropertyAggregateDescriptor allows you to define a property and a function that are applied over the property values of the DataGrid, which accumulates an aggregated result based on the component data.

To set up the PropertyAggregateDescriptor, use the following properties:

  • PropertyName—Defines the name of the property that is used to compute the aggregate value.
  • Function—Defines a KnownFunction value that will be applied to the aggregate.
  • Caption—Defines the caption of the aggregate. You can use Caption to display text in the UI.
  • Format—Defines the string format that will be applied over the aggregated value.

The PropertyAggregateDescriptor supports the following KnownFunction aggregates:

  • Sum - The Sum function sumarizes all values in the column.
  • Min - The Minimum value of the cells in the column.
  • Max - The Maximum value of the cells in the column.
  • Average - The Average value of the cells in the column.
  • Count - The COUNT function counts the items in the column.
  • Product - The PRODUCT function multiplies all the numbers given as arguments and returns the product.
  • StdDev - The Standard Deviation is a measure of how widely values are dispersed from the average value, based on a sample function.
  • StdDevP - The Standard Deviation is a measure of how widely values are dispersed from the average value, based on the entire population function.
  • Var - The Variance is a measure of dispersion, based on a sample function.
  • VarP - The Variance is a measure of dispersion, based on the entire population function.

The following example shows how to add a PropertyAggregateDescriptor to the DataGrid's Columns.

<telerikDataGrid:DataGridNumericalColumn PropertyName="StadiumCapacity"
                                         HeaderText="Stadium Capacity">
    <telerikDataGrid:DataGridNumericalColumn.AggregateDescriptors>
        <telerikCommon:PropertyAggregateDescriptor PropertyName="Price"
                                                Function="Min" 
                                                Format="C"
                                                Caption=" " />
        <telerikCommon:PropertyAggregateDescriptor PropertyName="Price" 
                                                Function="Max" 
                                                Format="C"
                                                Caption=" " />
        </telerikDataGrid:DataGridNumericalColumn.AggregateDescriptors>
</telerikDataGrid:DataGridNumericalColumn>

And the namespaces used:

xmlns:telerikDataGrid="clr-namespace:Telerik.XamarinForms.DataGrid;assembly=Telerik.XamarinForms.DataGrid" 
xmlns:telerikCommon="clr-namespace:Telerik.XamarinForms.Common.Data;assembly=Telerik.XamarinForms.Common"

See Also

In this article