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
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
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
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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.