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

VA Hierarchy and Custom Sort Field

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

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. 


Accepted Solutions
Solution
‎02-08-2017 11:41 PM
SAS Employee
Posts: 38

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.

View solution in original post


All Replies
Solution
‎02-08-2017 11:41 PM
SAS Employee
Posts: 38

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.

 

 customSort.PNG

Post a Question
Discussion Stats
  • 2 replies
  • 239 views
  • 0 likes
  • 3 in conversation