This is a migrated thread and some comments may be shown as answers.

Show aggregates aligned with columns

39 Answers 357 Views

GridView

This is a migrated thread and some comments may be shown as answers.

39 Answers, 1 is accepted

answered on 11 Nov 2010, 05:36 PM

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.

answered on 23 Dec 2010, 10:00 AM

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

answered on 23 Dec 2010, 01:14 PM

WpfApplication3_VS2010.zip

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

answered on 23 Dec 2010, 03:04 PM

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

answered on 24 Sep 2012, 10:47 AM

1.png

2.png

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

answered on 24 Sep 2012, 11:33 AM

Untitled.png

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.

answered on 24 Sep 2012, 11:43 AM

Grouprow.png

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.

answered on 24 Sep 2012, 11:58 AM

multiplegroups.png

Hi,

The first cell shows the Value of the Grouping.
In my example I have selected the customer to group by. So you see the customers name in the first cell. The other cells that are shown are the aggregations. If I would group by User it would show the username in the first column. I can even make sub groups see example

answered on 24 Sep 2012, 01:56 PM

img3.jpg

I understand that re-ordering columns (grouped columns show up first then the rest of them) although it would make the information much more easy to read it probably demands complex development and therefore time..

Having that in mind (and leaving that possibility open for a future development) I would propose an alternative that still keeps the information "ordered" but on the correct cells and that I hope it could come as part of the next release ;) :
Based on the image that Vlad posted "Untitled.png":
- the unit price should be aligned with the unit price column, the three rows (9, 13, 14) should have those values under the column unit price and not on the first cell like it is and it could have the count on the same cell.
- on the cell of the date column it should have both the min and max values and not only on the footer (for the case when the user doesn't want a footer...)

Check the image attached.

This way, although is not perfect, is still more organized and easier to read than the current situation because the cell values on the rows match the columns that they belong to.

Regards,
Carlos

answered on 25 Sep 2012, 12:38 PM

Untitled.png

Hi Carlos,

The situation is a bit more complicated since you can have sub groups as well. In this case the group header and the expand/collapse button are on different indentation while the header aggregates for all groups and sub groups should share the same indentation as columns headers.

I've attached a screenshot.

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.

answered on 25 Sep 2012, 03:33 PM

Ok. Looking at your example I kind of understand the problem but there are at least two things that I would change:

1 - location of the main information
UNIT PRICE
The information about the count and value on the beggining of the footer should be above "custom footer with aggregates" and not on the beggining of the footer because it doesn't mean anything to the column headers above of where it is located now.
DATE
The information about the count and value on the beggining of the footer should be above "min and max dates" and not on the beggining of the footer because it doesn't mean anything to the column headers above of where it is located now.
IF POSSIBLE
have the grouped value not only on the beggining of the header but also aligned below the colum it relates to...

2 - the group header value should be written on it's original format (I believe this is probably ok on the final product, is just this quick demo that doesn't have this)
ex: unit price: 18.4 -> $18.40
ex: date: 4/13/2007 12:00:00AM -> 4/13/2007

Carlos

answered on 19 Dec 2012, 07:42 PM

FooterTotal.png

I'm not sure why this is still an issue. As others have stated, this seems like simple expected functionality. Our users have expressed concern and "uber confusion" with the way group totals display. They have asked that the group totals be removed, leaving the total at the bottom of the grid in place. I haven't found the property to turn off (not show totals) in the group footer leaving the grand total showing at the bottom. There is is the "Show Column Footers" properties, but that turns off everything. Please tell me this is possible.

I've attached a image to show what I'm asking for.

Thanks
JD

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Show aggregates aligned with columns

39 Answers, 1 is accepted