topic Re: Categorical Sorting Issue in SAS Visual Analytics

Categorical Sorting Issue

thompsonke — Thu, 21 Jun 2018 20:26:43 GMT

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.

Re: Categorical Sorting Issue

SASKiwi — Sun, 24 Jun 2018 00:04:16 GMT

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.

Re: Categorical Sorting Issue

FredrikE — Mon, 25 Jun 2018 07:53:31 GMT

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