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

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 2259 views
  • 0 likes
  • 2 in conversation