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?
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.
if i dont have time data in date field. only date!
"yyyy-MM-dd" used this. but sorting still doesnt work
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 – http://www.flexmonster.com/doc/data-types-in-json/ and http://www.flexmonster.com/doc/data-types-in-csv/.
Let us know if everything works fine for you.
This is still a problem though date string is passed per recommendation by Dmytro. Can you help here on sorting of date.
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
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.