Show aggregates aligned with columns

40 posts, 0 answers
  1. Marcelo
    Marcelo avatar
    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
  2. Vlad
    Admin
    Vlad avatar
    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
  3. DevCraft banner
  4. Marcelo
    Marcelo avatar
    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.
  5. Maya
    Admin
    Maya avatar
    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
  6. Marcelo
    Marcelo avatar
    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
  7. Marcelo
    Marcelo avatar
    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
  8. Hristo
    Admin
    Hristo avatar
    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
  9. Marcelo
    Marcelo avatar
    24 posts
    Member since:
    Oct 2010

    Posted 12 Nov 2010 Link to this post

    Is this feature supported in the WPF version of GridView?
  10. Maya
    Admin
    Maya avatar
    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
  11. Marcelo
    Marcelo avatar
    24 posts
    Member since:
    Oct 2010

    Posted 12 Nov 2010 Link to this post

    Thanks
  12. Marcelo
    Marcelo avatar
    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)
  13. Maya
    Admin
    Maya avatar
    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
  14. Marcelo
    Marcelo avatar
    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?
  15. Marcelo
    Marcelo avatar
    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
  16. Maya
    Admin
    Maya avatar
    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
  17. Marcelo
    Marcelo avatar
    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
  18. Maya
    Admin
    Maya avatar
    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
  19. Marcelo
    Marcelo avatar
    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
  20. Maya
    Admin
    Maya avatar
    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
  21. CarlosLima
    CarlosLima avatar
    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.


  22. Marcelo
    Marcelo avatar
    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!
  23. CarlosLima
    CarlosLima avatar
    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

  24. Kevin Hendriks
    Kevin Hendriks avatar
    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.
  25. WILLIAM
    WILLIAM avatar
    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?
  26. Vlad
    Admin
    Vlad avatar
    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.

  27. Marcelo
    Marcelo avatar
    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.
  28. carlos
    carlos avatar
    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
  29. Vlad
    Admin
    Vlad avatar
    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.

  30. Kevin Hendriks
    Kevin Hendriks avatar
    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.
  31. Vlad
    Admin
    Vlad avatar
    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.

Back to Top
DevCraft banner