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