Some more functionallity wanted

9 posts, 0 answers
  1. Alex
    Alex avatar
    1 posts
    Member since:
    Aug 2012

    Posted 29 Aug 2012 Link to this post

    Greetings, 

    Yours PivotGrid is awesome, but would you mind to tell me eta on following functionality:
    • DrillDown (Recieve a part of datasource which fills the cell value);
    • Inline editor

    Best Regards, Alex D.
  2. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 03 Sep 2012 Link to this post

    Hello Alex,

    We have plans for implementing the desired functionalities. Unfortunately we could not commit the exact deadline when these functionalities will be included into the RadPivotGrid. However I will forward your requirements to our developers in order to increase the priority of the desired features.

    Kind regards,
    Radoslav
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Vinh
    Vinh avatar
    24 posts
    Member since:
    Jul 2010

    Posted 03 Oct 2012 Link to this post

    Also, another nice to have feature that I'm looking forward is the ability to do Calculated Column, which is the ability to do some basic mathematics, statistic functions of the selected columns.

    Thanks,

    VV
  5. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 08 Oct 2012 Link to this post

    Hi Vinh,

    Indeed the described feature could be very useful. I am forwarding your requirement to our developers.

    Regards,
    Radoslav
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  6. christian
    christian avatar
    7 posts
    Member since:
    Jul 2011

    Posted 10 Oct 2012 Link to this post

    A calculated column is also on top of my list. If a column shows you a statistic like the ratio of other values, the default aggregate functions don't make sense.

    We really love the new pivotgrid. Missing a calculated column is the only reason not to use it for our customers yet.
  7. Vinh
    Vinh avatar
    24 posts
    Member since:
    Jul 2010

    Posted 10 Oct 2012 Link to this post

    Hi,

    A calculated column/row is defined as a column/row can be created on client side (ajaxified).  Think about a client side calculator, it allows you to do any math functions based on the selected column(s)/row(s).
    1. Market Share is simply percent of total i.e. CurrentColumnValue/Sum(AllColumnValues).
    2. Lost Sales as we've been running it is Market Share from Last Year * Sum(AllColumnValuesCurrentYear) - CurrentColumnValue
    3. Beside the two above, the calcutor should have a few basic math functions, such as min, max, avg, med, %, *,/, +, -, etc...
      1. let say you have the grid below
          1.                   Year    2009, 2010, 2011, 2012
                             Sped        50,     45,     36,     51
          2. # Crew Member          8,      7,        5,      8
      2. and you use the calculator to select max() function and click on the column 2009, 2010, 2011, 2012 and named it as "Max of 4 Year"
      3. it will add a new column name "Max of 4 Year" so your grid will look like this
        1.             Year 2009, 2010, 2011, 2012, Max of 4 Year
                         Sped 50,     45,     36,     51,                   51
          # Crew Member 8,       7,      5,        8,                     8

      4. Same thing for calculated row, if you have a sum() and I do not select any rows, the you should treat it as a Grand Total. Other wise if you select sum() and give it a name "Sum" and select (#1,#3,#6), then the calculator should add those selected rows and create a new row with the name "Sum" and display the corresponding data. 

        1. Year 2009, 2010, 2011, 2012
          LL#1       1,       4,       5,      6
          LL#2       9,     10,     11,     12
          LL#3     10,     11,     12,     13
          LL#4     11,     12,     13,     14
          LL#5     15,     16,     17,     18
          LL#6     19,     10,     11,     12
          Sum      30,     25,     28,     31

      1. Also, as the end user, we need to have to ability to move the row up and down and of course, the sort will override this, but when you unsort, if still need to remember the last set position of the rows. Same thing should apply for column as well.
      2. If you engineers are interesting to see our window tool, you can send me an email and I'm more than happy to show you the tool.

     

           

  8. Chris Fitch
    Chris Fitch avatar
    4 posts
    Member since:
    Mar 2010

    Posted 24 Oct 2012 Link to this post

    I too, would very much like to see this functionality.
  9. Gerald
    Gerald avatar
    4 posts
    Member since:
    Feb 2012

    Posted 29 Oct 2012 Link to this post

    Article: http://www.telerik.com/help/aspnet-ajax/pivotgrid-overview.html

    Hi,

     

    How about adding the possibility for the user to save their particular settings for their particular view
    of data when using a RadPivotGrid? Appropriately this could be done in the PivotGrid/Configuration
    Panel.

     

    If you do not plan anytime soon to implement this feature, how would I be able to add
    a custom attribute/value to this control that would save the configuration settings in a javascript
    cookie which could be read upon their subsequent return?
     

     

     

     

    Thanks,
     

    Gerald

     

  10. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 01 Nov 2012 Link to this post

    Hi Gerald,

    Unfortunately we do not have built –in functionality for saving the RadPivotGrid settings. Currently we are  developing infrastructure for persisting controls settings, however it will be available int the next Q1 2013.

    If you need further assistance, do not hesitate to contact us again.

    Greetings,
    Radoslav
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017