sort in date doesnt work

Answered
sabby asked on August 31, 2017

i have one date field in pivot. i click on filters and sort it but in result date doesnt gets sort .. can you try from your end?

6 answers

Public
Tanya Gryshko Tanya Gryshko Flexmonster September 1, 2017

Hello Sabby,
Thank you for writing. Everything works fine on our side. Your issue may be related to the date format you are using. Please note that our component supports ISO 8601 date input format (other formats may be used, but results can be unexpected). You can find more details in our documentation. Please share your feedback.
Regards,
Tanya

Public
sabby September 1, 2017

if i dont have time data in date field. only date!

Public
sabby September 1, 2017
  • ISO date – "yyyy-MM-dd"    used this. but sorting still doesnt work 
  • filter works fine. 
  • sorrting descsending is not working
Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster September 4, 2017

Hello Sabby,
Thank you for the update. Please make sure that you are using the correct data type for your date data. It seems that you need date string for your case. Please check our documentation for more information - https://www.flexmonster.com/doc/managing-data-presentation-json and https://www.flexmonster.com/doc/managing-data-presentation-csv/.
Let us know if everything works fine for you.
Best regards,
Dmytro.
 

Public
TJ May 28, 2020

This is still a problem though date string is passed per recommendation by Dmytro. Can you help here on sorting of date. 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 28, 2020

Hello,
 
Thank you for writing to us.
 
In case the "Date" hierarchy is placed to rows or columns, sorting can be applied using the sort property of an appropriate element.
 
If the "Date" hierarchy is placed to measures, its sorting can be defined using the sorting property of the slice object.
 
We have prepared an example demonstrating both scenarios.
 
Detailed information about the slice object and its properties, including the ones dedicated to sorting, can be found in our documentation.
 
Finally, our team would like to note that the desired configuration can be modified through UI and received using the "Save" button.
 
We hope it works.
You are welcome to contact us in case additional questions arise.
 
Kind regards,
Illia

Please login or Register to Submit Answer