Show aggregates aligned with columns

40 posts, 0 answers
  1. Kevin Hendriks
    Kevin Hendriks avatar
    56 posts
    Member since:
    Feb 2009

    Posted 24 Sep 2012 Link to this post

    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
  2. Marcelo
    Marcelo avatar
    24 posts
    Member since:
    Oct 2010

    Posted 24 Sep 2012 Link to this post

    I fully second that - it's exactly how it should work.
  3. DevCraft banner
  4. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 24 Sep 2012 Link to this post

    Hi,

     In this case you will unable to show first column aggregate result - not all of our customers will be happy. This leads also to huge breaking change for the group row XAML - definitely not something we would like to introduce.

    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.

  5. Kevin Hendriks
    Kevin Hendriks avatar
    56 posts
    Member since:
    Feb 2009

    Posted 24 Sep 2012 Link to this post

    It would be nice if we could switch between the two solutions then.
  6. carlos
    carlos avatar
    14 posts
    Member since:
    Sep 2010

    Posted 24 Sep 2012 Link to this post

    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
  7. carlos
    carlos avatar
    14 posts
    Member since:
    Sep 2010

    Posted 25 Sep 2012 Link to this post

    Vlad: Is my proposal viable?

    Thanks,
    Carlos
  8. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 25 Sep 2012 Link to this post

    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.

  9. carlos
    carlos avatar
    14 posts
    Member since:
    Sep 2010

    Posted 25 Sep 2012 Link to this post

    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
  10. WILLIAM
    WILLIAM avatar
    134 posts
    Member since:
    Jun 2012

    Posted 19 Dec 2012 Link to this post

    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
  11. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 20 Dec 2012 Link to this post

    Hello,

     You can check our demo for more info on how to display various aggregates. 

    Kind regards,
    Vlad
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Back to Top
DevCraft banner