Order by aggregate function

[Dario Zanelli]

Hi,
I am using the aggregate function of the Telerik. see code below)

<GroupByExpressions>
<telerik:GridGroupByExpression>
<SelectFields>
<telerik:GridGroupByField FieldName="Category" HeaderText="Categoria" />
<telerik:GridGroupByField FieldName="RiskValue" Aggregate="Avg" HeaderText="Valore medio di rischio" />
</SelectFields>                                    
<GroupByFields>
<telerik:GridGroupByField FieldName="Category" HeaderText="categoria" />
</GroupByFields>                                   
</telerik:GridGroupByExpression>  
</GroupByExpressions>          

Is it possible to sort the columns according to the value of the aggregate function (average)?

Kind regards,

Dario Zanelli

[Martin]

Hello Dario Zanelli,

When you set your group by field, the GridGroupByField.SortOrder property determines how the different groups will be sorted. RadGrid by default applies Ascending sort order for that field. However, you can explicitly set Descending sort order using the SortOrder property of the relevant GridGroupByField object. To sort the different groups you can also use the sort button placed in the GroupPanel.
To sort the items in a group by a field different than the "group by" field, just click on e column header (as demonstrated in this online demo of the product). Note that the fields used in the group header item are irrelevant to the groups sorting.

I hope this helps

Regards,
Martin
the Telerik team

[Dario Zanelli]

Dear Martin,

probably I didn't explain my problem well.
I would like to sort the items of the RadGrid according to the aggregate function Average that I have calculated in the bold instruction.

<GroupByExpressions>
<telerik:GridGroupByExpression>
<SelectFields>
<telerik:GridGroupByField FieldName="Category" HeaderText="Categoria" />
<telerik:GridGroupByField FieldName="RiskValue" Aggregate="Avg" HeaderText="Valore medio di rischio" />
</SelectFields>                                    
<GroupByFields>
<telerik:GridGroupByField FieldName="Category" HeaderText="categoria" />
</GroupByFields>                                   
</telerik:GridGroupByExpression>  
</GroupByExpressions>          

Is it possible?

Kind regards,

Dario Zanelli

[Martin]

Hello Dario Zanelli,

As I stated in my previous post:

"Note that the fields used in the group header item are irrelevant to the groups sorting."

Based on the above I am afraid that sorting a grouped grid, based on an aggregate function value, displayed in the header item is not supported scenario.

Regards,
Martin
the Telerik team

[mctl87]

Did anything change since 2010? I would really like to have such feature in RadGrid even if it involves overriding/extending standard functionality.

After some research i also found this thread:
http://www.telerik.com/forums/about-reorder-by-sumfunction-value

But it seems that ASP NET AJAX RadGrid does not provide us with any object related to "GroupDescriptors" so if im not wrong, it's just not possible in ASP NET.


EDIT: Just found similiar thread so i should ask "since 2013"... :)
http://www.telerik.com/forums/possible-to-sort-by-aggregate-value-(descending)-when-grid-is-grouped-

[Maria Ilieva]

Hi Michał,

Unfortunately the required functionality is still not supported in the RadGrid control and sorting a grouped grid, based on an aggregate function value, displayed in the header item is not supported scenario.

Excuse us for any inconvenience this limitation may lead.


Regards,
Maria Ilieva
Telerik

 

 

[Derek]

Hi Maria,

Have there been any updates that would allow this functionality to be used now? Thanks!

 

[Eyup]

Hi Derek,

I am afraid this requirement is still not supported. You can cast your vote here:
https://feedback.telerik.com/Project/108/Feedback/Details/165036-group-sorting-by-totals-of-other-grouped-items

Regards,
Eyup
Progress Telerik