Show aggregates aligned with columns in UI for Silverlight GridView

Marcelo

24 posts

Member since:
Oct 2010

Posted 11 Nov 2010 Link to this post

Hi,

We've recently purchased the telerik package and I was playing around with the GridView. One feature that is king for our users is to be able to aggregate data on the grids freely (the users want to drag columns around themselves to create the groupings). I managed to do this following one of your demos but I can't figure out how to get the aggregated values to be aligned to their respective columns (this is a must for our users).

Can you please provide me with a working example on how to achieve this?

Thanks,

Marcelo

Vlad

Admin

11100 posts

Posted 11 Nov 2010 Link to this post

Hello Marcelo,

This is by default for the footers - please check this demo for more info:
http://demos.telerik.com/silverlight/#GridView/Totals

Greetings,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Marcelo

24 posts

Member since:
Oct 2010

Posted 11 Nov 2010 Link to this post

thanks for your quick reply.

right, I see what you mean, but I don't want a footer. I want the actual aggregates for each row displayed correctly aligned. The alignment of the footer would be fine, but I want it with the totals of the grouping headers (the totals in the footer are grand totals, that's not what I need).

Is there any way to achieve this?

I tried the sample project on this thread but it doesn't work well when you have two or more columns grouped (it works fine for one though).

When you have two or more and you start expanding the results you get the totals as footers instead of headers. I'm attaching a screenshot for yor reference.

Maya

Admin

4062 posts

Posted 12 Nov 2010 Link to this post

Hi Marcelo,

Unfortunately, for the time being the provided workaround in the link you posted in the only possible way for achieving this behavior. However, we do consider implementing this feature our-of-the-box so that you can use it natively. Most probably this functionality will be available in our Q1 2011 release.

Sincerely yours,
Maya
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Marcelo

24 posts

Member since:
Oct 2010

Posted 12 Nov 2010 Link to this post

It's a bit dissapointing to be honest that such a basic feature is not currently present. I can only blame myself for not having checked that this feature worked before buying the product but honestly the gridview is useless for us without it.

What is the ETA for the 2011Q1 release?

Thanks

Marcelo

24 posts

Member since:
Oct 2010

Posted 12 Nov 2010 Link to this post

Can the workaround provided in the sample project get fixed to work correctly for groupings of 2 or more levels please? I would be happy to temporarily use this workaround until the feature is properly implemented, but it currently works only for 1 grouping level.

Thanks

Hristo

Admin

408 posts

Posted 12 Nov 2010 Link to this post

Hi Marcelo,

Unfortunately the proposed workaround can work only for the 1st level grouping . This is the best result with the current implementation. This feature is with high priority for the Q1 2011 release which will be out in March next year.

Excuse us for the inconvenience caused.

Kind regards,
Hristo
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Marcelo

24 posts

Member since:
Oct 2010

Posted 12 Nov 2010 Link to this post

Is this feature supported in the WPF version of GridView?

Maya

Admin

4062 posts

Posted 12 Nov 2010 Link to this post

Hi Marcelo,

This feature is not available for our RadGridView for WPF either. However, once we introduce the feature out-of-the-box, it will be included for both platforms - Silverlight and WPF.

Sincerely yours,
Maya
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Marcelo

24 posts

Member since:
Oct 2010

Posted 12 Nov 2010 Link to this post

Thanks

Marcelo

24 posts

Member since:
Oct 2010

Posted 17 Dec 2010 Link to this post

Where can I track the progress of this feature? I couldn't find it in PITS (http://www.telerik.com/support/pits.aspx#/public/wpf/2011-q1)

Maya

Admin

4062 posts

Posted 20 Dec 2010 Link to this post

Hi Marcelo,

You may follow the progress of the feature request and vote for it here.

All the best,
Maya
the Telerik team

Browse the videos here>> to help you get started with RadControls for Silverlight

Marcelo

24 posts

Member since:
Oct 2010

Posted 20 Dec 2010 Link to this post

Thanks for that.

The feature shows as part of the Silverlight packaged. Will it be available for WPF as well?

Marcelo

24 posts

Member since:
Oct 2010

Posted 20 Dec 2010 Link to this post

Also, you said earlier that it was scheduled for 2011Q1, however it currently shows as unscheduled. Can you please update its status? Thanks

Maya

Admin

4062 posts

Posted 20 Dec 2010 Link to this post

Hello Marcelo,

The feature will be available for both Silverlight and WPF. The progress of the feature for WPF may be followed here.

All the best,
Maya
the Telerik team

Browse the videos here>> to help you get started with RadControls for Silverlight

Marcelo

24 posts

Member since:
Oct 2010

Posted 20 Dec 2010 Link to this post

Also, you said earlier that it was scheduled for 2011Q1, however it currently shows as unscheduled. Can you please update its status? Thanks

Maya

Admin

4062 posts

Posted 23 Dec 2010 Link to this post

Hi Marcelo,

Our plans are to include this functionality as soon as possible. However, there are quite many different scenarios to be covered and our intentions are to chose the best approach for the implementation of this feature. Consequently, there is a lot of research and testing to do.
On the other hand, as our priority is to satisfy as many of our customers' requirements as possible, we do take into consideration the rating of a particular feature request. Thus the higher the rating of this particular one is, the more important is it in our product backlog. So, I would definitely recommend voting for it.
Thank you for your patience and understanding.

Greetings,
Maya
the Telerik team

Browse the videos here>> to help you get started with RadControls for Silverlight

Marcelo

24 posts

Member since:
Oct 2010

Posted 23 Dec 2010 Link to this post

Thanks Maya.

I know this is the Silverlight forum, but can you please provide a WPF workaround for this problem in the mean time? I downloaded a Silverlight workaround from another thread (which only works for the first-level, which is better than nothing for now) but it doesn't work in WPF. Are you able to adapt it to work in WPF please? It would be massively helpful to at least have a temporary workaround so that I can show my manager that buying the Telerik package wasn't a total waste of money.

Many thanks again,

Marcelo

Maya

Admin

4062 posts

Posted 23 Dec 2010 Link to this post

Hello Marcelo,

I am sending you the sample project targeting WPF platform. I really hope it helps. In the meantime, please do not hesitate to contact us in case you need any assistance when working with our products.

Regards,
Maya
the Telerik team

Browse the videos here>> to help you get started with RadControls for Silverlight

WpfApplication3_VS2010.zip

CarlosLima

47 posts

Member since:
May 2010

Posted 23 Dec 2010 Link to this post

We've managed to solve the problem (or at least tried to) by adding a second row to the group bar (based on that sample)
http://www.telerik.com/community/forums/silverlight/gridview/complete-style-and-template-change-help.aspx

This way the footer values don't get mixed with the group header text.

Still has some wicked issue.. sometimes the values in the cells of the first grouped row (when expanded) are missing. Just "ungroup" and "re-group" again and it works. I have asked this on the forum but no reply with a solution yet.

Marcelo

24 posts

Member since:
Oct 2010

Posted 23 Dec 2010 Link to this post

Thanks for sharing that David.

If you don't mind could you please vote for this feature? it can be found here: http://www.telerik.com/support/pits.aspx#/public/silverlight/4389

the more people vote for it the more likely it'll be released sooner rather than later. If you know any other users (even within your own company) who are suffering from the same problems please encourage them to vote too.

Would you be able to upload a working sample of your source code?

Thanks!

CarlosLima

47 posts

Member since:
May 2010

Posted 23 Dec 2010 Link to this post

Sure.
https://www.yousendit.com/download/RlRwSXQwdVU5eFZjR0E9PQ

It's a work in progress to completely redesign the grid's look to be more "clean" (along with the whole site). A lot like the ones at the website www.mint.com.

- Still haven't found how to solve the "horizontal scrool bar" issue (in this case it shows only because of a border...)
- Still haven't found where to remove the extra bottom line in the group footer
- Still have to do some work on the grid column footer
- Would like to have the column filter icon visible when the values are actually being filtered and it only shows on mouse over or if the column is being sorted

Kevin Hendriks

56 posts

Member since:
Feb 2009

Posted 13 Sep 2011 Link to this post

This solution seems to work for me.
I have one question still. In the example provided the colors used are for the black style.
Can I easily let the Controltemple use the Style that is set by the telerik style manager.

WILLIAM

134 posts

Member since:
Jun 2012

Posted 21 Sep 2012 Link to this post

Has this feature been implemented yet? We have the same business requirement. I have several columns that do Sum calculation. The Footer shows correctly. When grouping, the calculations are shown left aligned. How are users supposed to correlate the value with a column?

Vlad

Admin

11100 posts

Posted 24 Sep 2012 Link to this post

Hello,

Only aggregates in the column footers are associated with columns. Aggregates in the group header are not related to columns in any way - can present completely different information (for example how many items you have in this group) and can vary in numbers (not equal to the columns collection).

Kind regards,
Vlad
the Telerik team

Time to cast your vote for Telerik! Tell DevPro Connections and Windows IT Pro why Telerik is your choice. Telerik is nominated in a total of 25 categories.

Marcelo

24 posts

Member since:
Oct 2010

Posted 24 Sep 2012 Link to this post

When is this feature going to be implemented? I has plenty of votes now!! Without this feature the grid is useless for any financial application.

carlos

14 posts

Member since:
Sep 2010

Posted 24 Sep 2012 Link to this post

It's been almost two years since we started this discussion and so far this issue is still not properly resolved.
It's really easy to understand the problem it causes for finantial analysis just by creating this simple example (we had this situation recently so it's a very real case...):
- Create a gridview with 36 columns where the first 5 are item identifications (name, id, category, etc) and the rest are all diferent types of prices. Now group the table by category (which will create an avg and sum of each price) and try to make a sense of the results... you have to scroll to the far end of the table to find the column name of price 32 and come back to count the items on the bar to find out which price is the n.32... it's a mess and very far from any professional product.

I can't imagine how complicated it might be for telerik to adjust the grid to properly align the contents of the grouped bar to it's "parent" column, but it's a very very very important feature (probably the only thing the control lacks right now) specially because it's the expected behaviour by any common "excel" user that gets very surprised to see what happens when he uses the groupby feature (usually the first words that come out of his mouth are "up's what did I do?").

Attached are images based on the current gridview for silverlight demo of what is showing right now and what everyone here is demanding.

Please keep us updated like you did on the pivotgrid and together we can help you set priorities for the grid's development.

Thanks,
Carlos

2.png
1.png

Vlad

Admin

11100 posts

Posted 24 Sep 2012 Link to this post

Hello,

This feature will be part of our upcoming Q3 2012 release (middle of October). It will not look exactly like the image you've attached since there is no way to have both group header and aligned column aggregates on the same row however you will be able to show additional row under the group header with aligned aggregates.

I've attached a screenshot for more info.

Greetings,
Vlad
the Telerik team

Time to cast your vote for Telerik! Tell DevPro Connections and Windows IT Pro why Telerik is your choice. Telerik is nominated in a total of 25 categories.

Untitled.png

Kevin Hendriks

56 posts

Member since:
Feb 2009

Posted 24 Sep 2012 Link to this post

Hello,

It IS possible to have it in the same row. see attached image. The solutions for it is even in this thread. When a row is collapsed it is on the header when it is expanded it is below it. Current problem we only have (as you can see) is that we do not have the themed colours on it. Have the sums on the grouped rows is really an requirement because we can have dozens of rows in a grid depending on how it is grouped.

Grouprow.png

Vlad

Admin

11100 posts

Posted 24 Sep 2012 Link to this post

Hi,

In this case what do you show in the first cell? Group header? First column aggregate result?

All the best,
Vlad
the Telerik team

Time to cast your vote for Telerik! Tell DevPro Connections and Windows IT Pro why Telerik is your choice. Telerik is nominated in a total of 25 categories.