BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ghartge
Quartz | Level 8

Greetings everyone,

 

I have a simple bar chart based on headcount in counties. There is one county that most of our data is from but there are 64 others. I can restrict the bars that are shown using a filter on headcount such as "Headcount > 300", but as selections are made in the report using dropboxes, all values for all counties can drop below the 300 value rendering a one bar chart or worse, blank. My question is does SAS VA allow for the filter to be dynamic or maybe something like "only show the top 10 values". (Please see the attached picture)

 

Thank you, everyone!

 

Gary

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

It should work using rank on headcounts and only show the top 10, 15 or whatever you want. Click on the rankings tab to the right.

//Fredrik

View solution in original post

2 REPLIES 2
FredrikE
Rhodochrosite | Level 12

It should work using rank on headcounts and only show the top 10, 15 or whatever you want. Click on the rankings tab to the right.

//Fredrik

ghartge
Quartz | Level 8

Thank you FredrikE! Sometimes it is the simplest things that escape us no doubt. Blessings

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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