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

Want to display all my values in the filter

Reply
Contributor
Posts: 27

Want to display all my values in the filter

Hi,

In one of the report ( please see screen shot) i have a filter where values are more then 1000, but the VA is not displaying them, which is creating lots of issues in the Analysis,

 

is her a way to display all the values?

 

from the unlisted value my senior management want to select few and soe times all so what i need is following

 

1. is there a way to search the value ( as currently i am unable to search as VA throws an error if i want to search a value which is in unlisted bucket)

2. is there a way to search and select multiple values from the unlisted bucket as well from the main list?

3. can i display all

4. can i have another drop down filter where i can only display unlisted values from the previous filter?

 

many regards and thanks in advance to all who will respond


sas.JPG
Frequent Contributor
Posts: 123

Re: Want to display all my values in the filter

Is it possible to another column to your table with additional catagorization.  For instance assign the station numbers to groups like (1000-1999, 2000-2999, 3000-3999) or prefilter to remove any stations that have smaller values? I realize this does not change the filters but it may allow you to better catagorize the data so the report drop-down could change it. 

 

Possibly it will just give you some ideas about how to resovle the issue.


Tricia Aanderud
Zencos Consulting
Twitter: @taanderud - Follow me!

Contributor
Posts: 27

Re: Want to display all my values in the filter

and if the values are Character type?

Frequent Contributor
Posts: 123

Re: Want to display all my values in the filter

You can use the Custom Category option to organize the values.

 

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n133d7vjj5losnn0zber8...

 

Another option is to do it in SAS code.  If the station numbers look like numbers - then change it to a numeric value and create your new category.


Tricia Aanderud
Zencos Consulting
Twitter: @taanderud - Follow me!

Ask a Question
Discussion stats
  • 3 replies
  • 341 views
  • 1 like
  • 2 in conversation