topic Re: VA Hierarchy and Custom Sort Field in SAS Visual Analytics

VA Hierarchy and Custom Sort Field

arnouxvr — Wed, 08 Feb 2017 01:10:38 GMT

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.

Re: VA Hierarchy and Custom Sort Field

RickStyll_SAS — Thu, 09 Feb 2017 03:49:42 GMT

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.

Re: VA Hierarchy and Custom Sort Field

juliamorgan — Thu, 04 May 2017 23:24:04 GMT

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.

Re: VA Hierarchy and Custom Sort Field

arnouxvr — Wed, 07 Jun 2017 03:20:29 GMT

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.)

Re: VA Hierarchy and Custom Sort Field

_kimi_ — Fri, 04 Nov 2022 00:13:35 GMT

I have a situations where I have to sort a Priority List which can take values from A20 - A1 and B20 - B1. However, many of those values are currently missing. Can I sort the variables in a descending order (all the 40 variables) so that when the currently missing values appear in future, this will be automatically sorted in the dashboard?

Re: VA Hierarchy and Custom Sort Field

acordes — Fri, 04 Nov 2022 12:20:44 GMT

Probably you can fix it by putting an aggregated table in between.
The custom category should become static once brought to the aggregated table.
Try it.