Completed
Last Updated: 13 Mar 2024 06:02 by ADMIN
Release 2024 Q2 (May)
lakshman
Created on: 02 Mar 2020 16:34
Category: Grid
Type: Feature Request
48
Group Header and Footer templates should expose aggregates for all the fields

Hello,

Do you have any sample for custom group Header template.

 

e..g. To  calculate the value of the column based on the other fields.

---

ADMIN EDIT

---

Once aggregates for all fields are exposed, we will need to provide an option to align them with the corresponding columns. This can be achieved through a GroupHeaderColumnTemplate which is targeted in a separate request.

14 comments
n/a
Posted on: 19 Jan 2024 21:29
Just adding a request for this feature as well.  We have two columns and would like to use the sum of each column in a formula group_aggregate_sum(column 1) / group_aggregate_sum(column 2) at the group footer level of column 3.
n/a
Posted on: 04 May 2023 14:00
Adding a comment supporting this functionality.  Our work around was to develop the application using ASP.Net Core, which exposed a bug in the 'count' function.  We can at least initially render the page with totals across all desired columns header groups.  Would like this same feature in Blazor.
Joseph
Posted on: 19 Apr 2023 02:06
It would be nice to have a feature like this.  The current lack of aggregates in the grid column headers make using aggregates pretty limited.  Excel and Telerik Reporting both use this format for group by totals.
ADMIN
Nadezhda Tacheva
Posted on: 26 Jan 2022 10:15

Hi all,

The current request targets two aspects and while they might be connected, we've discussed and concluded that it will be better to have them as separate threads for easier tracking:

  • Exposing aggregates for all the fields in Group Header and Footer templates - this will be covered by the current thread

  • Align the content (aggregates) of the Group Header with the columns - this will be covered by a separate request for GroupHeaderColumnTemplate. You may additionally vote for it and follow it to receive status updates via email.

Regards,
Nadezhda Tacheva
Progress Telerik

Learn about the important changes coming in UI for Blazor 3.0 in January 2022!
ADMIN
Marin Bratanov
Posted on: 01 Jan 2022 10:37

Hello,

When this feature becomes implemented there will be documentation and examples on handling it. Right now, I cannot offer a very good example. Perhaps something similar to this can be used to hack elements into alignment, but I recommend you don't try it in your case as I remember your recent tickets and what you are trying to achieve with the grid, and it won't work for you.

 

Regards,
Marin Bratanov
Progress Telerik

Learn about the important changes coming in UI for Blazor 3.0 in January 2022!
Nemo
Posted on: 31 Dec 2021 15:16
Attached a pic showing the group totals on the top, thanks.
Attached Files:
Nemo
Posted on: 31 Dec 2021 15:13
Hi Marin, yes we want to see the totals per column in the footer show up in the group row header. The advantage is that you can see the totals without having to expand the group row. User will expand the group row only if he wants to see the individual values which sum up to the total. We can create our own header template, but not sure how to align the values per column. Any samples or suggestions on how this can be implemented? Thanks.
ADMIN
Marin Bratanov
Posted on: 27 Jul 2021 04:51

Thanks, Rob, now I see - basically, you need the same ability like in the grand total footers, but also in the group templates. I've tweaked the title of this request because I find them related and I think everyone looking for one might benefit from the other too.

Regards,
Marin Bratanov
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Rob
Posted on: 26 Jul 2021 12:36

Thanks Marin,

My use is that I have a grid with Sales, Costs and Margin columns, with margin calculated from the first two. I'd like the group to calculate margin also, but the correct value is not able to be calculated from the Margin column alone.

ADMIN
Marin Bratanov
Posted on: 24 Jul 2021 09:00

Hi Rob,

The "grand totals" footer already exposes all aggregates, you can see how to get them here: https://docs.telerik.com/blazor-ui/components/grid/templates/column-footer.

The "group footer" is already specific for its column and lets you align the values for aggregating that particular column to its own column: https://docs.telerik.com/blazor-ui/components/grid/templates/column-group-footer.

Am I missing something from the situation you have, because it seems to me like this is already possible for the footers?

Regards,
Marin Bratanov
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Rob
Posted on: 23 Jul 2021 18:34
Also footer.  I don't see a way to calculate a group's margin without this..
ADMIN
Marin Bratanov
Posted on: 03 Mar 2020 09:25

Hello,

I updated the title and moved this idea to our Feedback Portal so the community can weigh in on whether they want such a feature. You can click the Follow button on the following page to get notifications for status updates: https://feedback.telerik.com/blazor/1456063-group-header-templates-should-expose-aggregates-for-all-the-fields-and-allow-you-to-align-them-with-the-columns. At the moment, the group headers only provide the aggregates for their own field, and they are not tied to columns.

 

Regards,
Marin Bratanov
Progress Telerik

 UI for Blazor
lakshman
Posted on: 02 Mar 2020 17:52

Hello Marin, thanks for quick reply. I was looking for custom aggregate function...attached image.

 

Does Telerik Blazor grid support custom aggregate functions with groupings?

 

 

 

Attached Files:
ADMIN
Marin Bratanov
Posted on: 02 Mar 2020 16:53

Hi,

You can find examples of defining aggregates for the fields you want and using them in the group header in the following resources:

What's important is that a group is defined by the field it groups by, so it can only show aggregates for that particular field. The group header knows only about its particular field, the footers of individual columns can show data for the respective column. If you have the desired data elsewhere, you can render it in the header template like in any other render fragment.

Regards,
Marin Bratanov
Progress Telerik

 UI for Blazor