I am using SAS Viya Visual Analytics. I am creating a line chart that has yearly quarters on the x axis (2017Q1, 2017Q2, etc.). On some of these charts the order gets completely scrambled. The data is sorted correctly in the data set, and I even attempted to apply a custom sort in VA.
Have you tried a time-series plot rather than a line chart? You need your x-axis variable to be a proper SAS date for this - is it? You will see a clock icon tagging the column if it is.
Have you done the sorting on the object and is it still there?
I have noticed that the sorting some times is lost when working with other ocjects or data items.
I often need to do the sorting again, before the report is done :0
//Fredrik
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.