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

Sorting bars in a bar chart

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Sorting bars in a bar chart

Hi all

I have a variable, e.g. profit, and three categories in a bar chart: x, y and z. Right now the categories are sorted decending resulting in the order x y z.

I have linked it with a regional map, such that when you click a region the bar chart shows the information for the given region. The problem is that the since profits are different across regions the categories shuffle, so now it may be z x y or x z y.

Is there a way to maintain the orginal order when looking at different regions. So that I always have x y z even if y has the highest profit?

Thanks in advance
Kasper


Accepted Solutions
Solution
‎08-22-2016 03:01 AM
SAS Employee
Posts: 13

Re: Sorting bars in a bar chart

Kasper, Have you tried a custom sort on the category - X Y Z?  I was able to create a report in the Visual Analytics Designer that had a regional map with a section link to a Bar Chart.  My testing showed that that when changing regions (cities in my case) the bar chart honored the custom sort since it is not based on values. Shannon

View solution in original post


All Replies
Solution
‎08-22-2016 03:01 AM
SAS Employee
Posts: 13

Re: Sorting bars in a bar chart

Kasper, Have you tried a custom sort on the category - X Y Z?  I was able to create a report in the Visual Analytics Designer that had a regional map with a section link to a Bar Chart.  My testing showed that that when changing regions (cities in my case) the bar chart honored the custom sort since it is not based on values. Shannon

New Contributor
Posts: 3

Re: Sorting bars in a bar chart

Thank you Shannon, it worked.

 

I had apparently not specified whether the bar chart should be sorted ascending or descending, but once I did that it honored the custom sort.

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