Group Settings: order of columns date

[JORGE V]

Hello,

I have a problem with the visualization of dates (the order) when the dates involces 2 years.

1- Without group settings (fecha = date) 

   ...

  columns : [{ name: 'fecha' }]

  groupSettings: []

  the visualisation is Ok : 2021-12-30   2022-01-01 ...

2- But with group settings

   ...

  columns : [{ name: 'fecha' }]

  groupSettings: [

{ name: 'fecha', type: 'Date', groupInterval: ['Days'] }

]

the visualization is wrong: 1-Jan (2022) .....30-Dec (2021).

30-Dec (today) is displayed at the end instead at first.

With group settings:

   { name: 'fecha', type: 'Date', groupInterval: ['Years','Months','Days'] },

   the visualization is OK (I added Years in the group) but I dont' want to include years in the group.

It seems that 'Days' does not take into account the year.

Thanks in advance !

Jorge

Attachment: 20211230_dates_2021_at_end_instead_first_232e9547.zip

[Manikandan Murugesan]

Hi Jorge, 

Please use the format settings without grouping to display the headers as needed. Please refer the code example below. 

Code Example: 

let dataSourceSettings = { 

  formatSettings: [ 

    { name: 'Date', type: 'date', format: 'dd-MMM' }, 

  ], 

}; 

 

  

Meanwhile, we have prepared a sample for your reference. Please find it from below link. 

Sample: https://stackblitz.com/edit/react-bd2nqp?file=index.js 

 

For more details about the “date formatting”, please refer the document link below. 

Document: https://ej2.syncfusion.com/react/documentation/pivotview/how-to/customize-number-date-and-time-values/#date-and-time-formatting 

 

Please let us know if you have any concerns. 

Regards, 

Manikandan