BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
KKJ-dk
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
ShannonMoore
SAS Employee

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

2 REPLIES 2
ShannonMoore
SAS Employee

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

KKJ-dk
Fluorite | Level 6

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.

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 2258 views
  • 0 likes
  • 2 in conversation