Dear SAS VA Experts,
Could you please suggest on the following requirement. Thanks in advance,
The Bar chart looks like the below.
The Sorting order needs to be changed to
Early -> On Time -> Undelivered -> 1 Day Delay -> 2 Days Delay -> 3 Days Delay -> >3 Days Delay.
The Custom Sort option that Peter showed above in the screen shot above became available within SAS Visual Analytics 7.1
Here some explanation regarding the work-around.
At first check if you can change/update your data source in a way you get a date instead of a month description.
With a date its easy using date formats in your reports that sort well.
Work-around is to create a new custom category where the labels are created in a way that alphabetical sorting will lead to the right result. (as mentioned before)
So group Jan to 1.Jan Feb to 2.feb etc.
Now you have a new variable that contains the values 1.Jan/2.feb/3.mar etc, that can be used in a report or graphic as the right sorting sequence.
Other option would be to use 1/2/3/4 etc as period labels to show the number of the month, as often done in financial reporting (Fin.Period)
The labels are not perfect, but the sorting is correct now.
That's what I called a possible work-around I once used to fix such a problem.
In you case I would surely fix the field in the database to match a Date format if possible, or even update to 7.1.
Greetings and succes.
As Peter points out, he has provided a work around in SAS VA 6.4. The custom sort dialog is new in 7.1
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.