topic Re: SAS/VA actions between a drop down on one page and a line graph on another page in SAS Visual Analytics

SAS/VA actions between a drop down on one page and a line graph on another page

elkinsbe — Sun, 02 Apr 2023 14:52:13 GMT

on page 1 of my report, I have drop down menus for Country, State, County and City... and I want the selections to interact with all the objects on all the pages of the report..... How do I do that??? Thanks in advance for everyone's assistance....

Re: SAS/VA actions between a drop down on one page and a line graph on another page

HunterT_SAS — Mon, 03 Apr 2023 12:12:07 GMT

There are two ways to do this.

The first way, which is the easiest - If you haven't done this already, from the main Options menu (three dot menu in the upper right corner), select Expand Report Controls:

This should add a new prompt area to the top of your report:

Any prompt or control you set here will automatically filter content on every page in the report, provided the same data is used in the prompts and report objects OR if different datasources are used then they are appropriately mapped.

Another tip here - if you need to use a List Control then you first have to place a Prompt Container here, then put your List Control inside of the prompt container.

The second way is a little more complicated. You would need to create a Parameter for each prompt, and then use the parameter in a local filter against whatever object on whatever page you wanted. Using your example, with a drop down list on page 1 and a line chart on page 2, I would create a parameter and assign it to the Parameter role of the Drop Down list. Then I would add a Filter to the Line Chart using that parameter (e.g. MyDataItem = MyParameter), and then repeat for all prompts and report objects that matter.

Re: SAS/VA actions between a drop down on one page and a line graph on another page

Sam_SAS — Mon, 03 Apr 2023 12:43:14 GMT

The advantage to using parameters is that you can control which content is affected by the prompt.

If you make a report prompt, then everything will be filtered by that prompt.