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

Too Many Drop Down Values

Reply
Regular Contributor
Posts: 182

Too Many Drop Down Values

I need to report information at customer level. I have around 60K customers. The data is shown below for 1 customer. The same kind of information would be for other 60k customers. There are 7 metrics against each customer so there would be (60K * 7 =420,000 rows in the data).

 

Customer Metrics Scores
ABC Balance 100005
ABC Income 25000
ABC Tenure 20
ABC Products A
ABC Category AA
ABC Risk A+
ABC Value B

 

My requirement is to have a drop down to select a customer and the respective metrics scores would be displayed in a list table. The problem i am facing here is SAS VA is unable to take 60K unique customers' name in a drop down. The data do not get loaded in the drop down. Is there a way to do it? Any option other than drop down?

SAS Super FREQ
Posts: 706

Re: Too Many Drop Down Values

Hi

 

How about using a different approach, enter parts of a customer name and filter the list table based on the entered text. See this video https://www.youtube.com/watch?v=g-ZWxX4jxRU by @TeriPatsilaras_sas

 

Have not tested it, but using a Text Input Control where you assign your category, allows you to start typing the first letters of the customer name

 

Bruno

http://blogs.sas.com/content/sgf/2015/01/29/using-parameters-in-sas-visual-analytics Teri Patsilaras demonstrates two advanced applications of using parameters in SAS Visual Analytics reports. The first example uses a single parameter as both a search criteria filter and a custom calculated data ...
Regular Contributor
Posts: 182

Re: Too Many Drop Down Values

Thank you so much for your suggestion. I would test it. It seems there is also a restriction on number of rows in a list table. The maximum threshold is 40K. Can we change it?
SAS Super FREQ
Posts: 706

Re: Too Many Drop Down Values

Hi

 

As far as I know, this is not possible.

 

Bruno

Trusted Advisor
Posts: 1,295

Re: Too Many Drop Down Values

Hi,

 

It might be possible to change the default cardinal it's setting of 40,000 as outlined in the documentation, however I'd question whether the increase client resource consumption is wise and perhaps a better approach to address your requirement with filtering the data first is best.

 

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

 

Kind Regards,

Michelle

Ask a Question
Discussion stats
  • 4 replies
  • 397 views
  • 0 likes
  • 3 in conversation