topic Re: Want to display all my values in the filter in SAS Visual Analytics

Want to display all my values in the filter

TestingSAS — Fri, 06 May 2016 16:42:07 GMT

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

Re: Want to display all my values in the filter

TriciaAanderud — Sat, 07 May 2016 10:06:28 GMT

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.

Re: Want to display all my values in the filter

TestingSAS — Wed, 11 May 2016 15:25:24 GMT

and if the values are Character type?

Re: Want to display all my values in the filter

TriciaAanderud — Wed, 11 May 2016 16:18:20 GMT

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

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

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.