Can not get datetime dimension hierarchy with pivot grid local binding

4 posts, 0 answers
  1. Lorenzo Sforzini
    Lorenzo Sforzini avatar
    6 posts
    Member since:
    Jul 2010

    Posted 27 Dec 2016 Link to this post

    Hi,

    we are using Pivot Grid kendo control with local binding. We have a datetime field in the data source but we are not able to get a datetime hierarchy for it in the pivot grid configurator component. In your demos for local binding there is no example using datetime fields while they are present in the remote binding demos. Is is still possible? Besides, we are noticing that measures only support sum aggregation natively. 

    We used to work with Silverlight version of Pivot Grid where basic datetime hierarchy (e.g. day, month, year, etc.) and many measures aggregations (dropdown list that allowed to select for sum, count, etc.) for local binding weresupported, now we are porting that application to HTML5 and we are trying to get back as many functionalities as we can.

    Thank you.

  2. Viktor Tachev
    Admin
    Viktor Tachev avatar
    1741 posts

    Posted 29 Dec 2016 Link to this post

    Hello Lorenzo,

    The way you bind the PivotGrid widget should not affect the types of fields you can use. As long as the data is passed in the correct format you should be able to use Dates.

    With that said, note that the PivotGrid is keeping the dimension values as strings. Check out the following thread that discusses formating date fields.



    Regards,
    Viktor Tachev
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Lorenzo Sforzini
    Lorenzo Sforzini avatar
    6 posts
    Member since:
    Jul 2010

    Posted 30 Dec 2016 in reply to Viktor Tachev Link to this post

    Hello Viktor,

    thanks for your reply.

    I had a look at the thread you pointed, we'll give it a try, however, what we missed is actually the built-in datetime hierarchy (e.g. month, year, quarter, etc.) for datetime dimensions.

    In fact, workink with strings is quite limiting... 

  4. Viktor Tachev
    Admin
    Viktor Tachev avatar
    1741 posts

    Posted 03 Jan Link to this post

    Hi Lorenzo,

    I understand your concerns, however, when you parse the value to a Date object you can take advantage of the functionalities Date provides.

    Regards,
    Viktor Tachev
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top