Drop down in SAS VA

[priyabhardwaj]

Hi,

I want a line chart where x-axis has dates and y-axis has values from columns(all numeric) selected from a drop down menu.

So, in the same graph if I select Col A from drop-down then graph shows Col A vs time, if I select Col B from drop-down then graph shows Col B vs time and so on. The difficulty here I'm facing is I can assign only one column at a time to the role option for the drop down.

Any way round this? 

Any help will be appreciated. Thanks a lot 

[upadhi · Accepted solution]

Hi this will will help you.

https://blogs.sas.com/content/sgf/2016/04/27/use-parameters-to-pick-your-metric-in-visual-analytics-...

In here for step 1, if your data is such that you can not create a custom category. Use a dummy table with one column and values Col1, Col2...

[priyabhardwaj]

Thank a lot @upadhi. It works.