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

Can not get datetime dimension hierarchy with pivot grid local binding

3 Answers 57 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Lorenzo Sforzini
Top achievements
Rank 1
Lorenzo Sforzini asked on 27 Dec 2016, 08:10 AM

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.

3 Answers, 1 is accepted

Sort by
0
Viktor Tachev
Telerik team
answered on 29 Dec 2016, 02:58 PM
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.
0
Lorenzo Sforzini
Top achievements
Rank 1
answered on 30 Dec 2016, 05:08 PM

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... 

0
Viktor Tachev
Telerik team
answered on 03 Jan 2017, 12:52 PM
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.
Tags
PivotGrid
Asked by
Lorenzo Sforzini
Top achievements
Rank 1
Answers by
Viktor Tachev
Telerik team
Lorenzo Sforzini
Top achievements
Rank 1
Share this question
or