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
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
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
Thank you FredrikE! Sometimes it is the simplest things that escape us no doubt. Blessings
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.