topic Re: Drop down in SAS VA in SAS Visual Analytics

Drop down in SAS VA

priyabhardwaj — Mon, 22 Apr 2019 09:29:36 GMT

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

Re: Drop down in SAS VA

upadhi — Mon, 22 Apr 2019 10:46:57 GMT

Hi this will will help you.

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

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...

Re: Drop down in SAS VA

priyabhardwaj — Mon, 22 Apr 2019 11:40:06 GMT

Thank a lot @upadhi. It works.