Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

VA Hierarchy and Custom Sort Field

Posts: 25

VA Hierarchy and Custom Sort Field

I have a variable that I changed to have a custom sort. When assigning the variable to a role of an object it sorts according to the custom sort which is correct.


However, when I create a new Hierarchy with the custom sort variable described above as the first level the new Hierarchy variable does not sort according to the what was set with the custom sort. 

SAS Employee
Posts: 86

Re: VA Hierarchy and Custom Sort Field

I wasn't able to recreate this issue in VA 7.3. I checked to ensure the custom sort was correct for the first level of a hierarchy in both a crosstab and a bar chart. Note that for a bar chart, the initial sort is by the measure and descending. To get the custom sort, you have to right click on the category label and choose sort while in Designer.

Occasional Contributor
Posts: 11

Re: VA Hierarchy and Custom Sort Field

[ Edited ]

I have the extact same problem.


When I use the variable it works fine with the custom sort.


When I use the same variable in a heirachy, the custom sort disappears. However, it is fine in the actual graph - the problam is only in the legend.


One is just using the variable, 2 is the heirachy.



Using v 7.3.



Posts: 25

Re: VA Hierarchy and Custom Sort Field

Posted in reply to juliamorgan
This is actually a limitation of Visual Analytics at this stage, as according to the documentation, a custom sort does not work if the data item is assigned to one of the legend data roles (either Colour or Group). The same restriction applies when sorting on the raw values of a data item that has a user-defined format.

Creating a user-defined format is a possible workaround. Instead of having your Risk Rating - Raw column having values such as AA, A, B1 etc. you would have the column as a number format (1, 2, 3), then add a user-defined format to invoke the Risk Ratings (example, 1 = ""AA"", 2 = ""A"", 3 = ""B1"" etc.)
Ask a Question
Discussion stats
  • 3 replies
  • 3 in conversation