topic Re: Sorting bars in a bar chart in SAS Visual Analytics

Sorting bars in a bar chart

KKJ-dk — Wed, 17 Aug 2016 12:55:27 GMT

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

Re: Sorting bars in a bar chart

ShannonMoore — Fri, 19 Aug 2016 19:33:25 GMT

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

Re: Sorting bars in a bar chart

KKJ-dk — Mon, 22 Aug 2016 07:01:11 GMT

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.