Special grouping for columns with dates?

[NicolasParticipant]

Hi,

I have a column of “date” (type of column is date). When I group on this column, the behavior is pretty useless : it group every item with exact same date… But every date I have are different!

For me, it would be much more useful if the grouping on a date column would create two level of grouping : first with the years, and the second with the months.

Example :
2013
->january
–> item 1
->july
–> item 2
–> item 3
2012
-> october
–> item 4

Is there a neat way to do this?

[Peter StoevKeymaster]

Hi Nicolas,

It is not possible to change the DataGrid grouping behavior.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[NicolasParticipant]

Ok, for now I’ll try to do this : I will create two hidden columns where I will extract the year and the month of the date. And when I’ll catch a groupchange event, I will replace my date column by the year column and the month column.

But it would be great if there was a more convenient way to do create custom grouping. As it is now, grouping on dates aren’t really useful. Same thing with numeric : it would be much more useful if we could group numeric by range. It is fine if I have to write the function that tells how to group, but right now it is a little bit cumbersome to do it.

Regards

[Author]

Posts