BookmarkSubscribeRSS Feed
thompsonke
Fluorite | Level 6

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.

2 REPLIES 2
SASKiwi
PROC Star

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.

FredrikE
Rhodochrosite | Level 12

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

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 935 views
  • 0 likes
  • 3 in conversation