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?
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
if i dont have time data in date field. only date!
"yyyy-MM-dd" used this. but sorting still doesnt work
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.
This is still a problem though date string is passed per recommendation by Dmytro. Can you help here on sorting of date.
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