priyanka patil 2 Posted August 11, 2020 Share Posted August 11, 2020 input :[FY19-P01,FY19-P02,FY19-P04,FY19-P03,FY19-SY-P07,FY-SY-P10,FY-SY-P09,FY20-FEB,FY20-APR,FY20-JAN,FY20-MAR] output:[FY19-P01,FY19-P02,FY19-P03,FY19-P04,FY19-SY-P07,FY-SY-P09,FY-SY-P10,FY20-JAN,FY20-FEB,FY20-MAR,FY20-APR] in future if data increase it should be able to sort exmaple Fy21-JAN,Fy21-FEb Link to comment Share on other sites More sharing options...
Ajinkya Gutti Posted August 17, 2020 Share Posted August 17, 2020 Spotfire automatically sorts filters in asceding order - it is doing so in this case as well - but the result is not as intended because the data is in form of a string rather than date/month. So for the filter to be in date wise ascending order you will have to process that column and bring it to one of the supported date formats Ex: "FY20-Jan" -> "2020 - Jan" Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now