Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Is it possible to only display a number columns in a bar chart as interactions are selected?

Accepted Solution Solved
Reply
Contributor
Posts: 34
Accepted Solution

Is it possible to only display a number columns in a bar chart as interactions are selected?

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

 

 


Accepted Solutions
Solution
‎08-30-2017 06:25 AM
PROC Star
Posts: 391

Re: Is it possible to only display a number columns in a bar chart as interactions are selected?

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


All Replies
Solution
‎08-30-2017 06:25 AM
PROC Star
Posts: 391

Re: Is it possible to only display a number columns in a bar chart as interactions are selected?

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

Contributor
Posts: 34

Re: Is it possible to only display a number columns in a bar chart as interactions are selected?

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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