Passing filters in linked reports

Nigel_Pain — Tue, 19 May 2020 11:40:28 GMT

I'm trying to get my head around how to pass filters in one report to another. It's mainly as an aid to learning but using data which could give me useful information as well.

I'm using data with a record per SAS session per user, and have a report with a bar chart of SAS usage. The category is an organisation hierarchy (Department, Division, Branch, User) and the measure is an aggregated measure of the number of distinct users in the bygroup. There is also a slider report control to filter on date of use (a range). As well as being able to drill down through the hierarchy I tried to create a link to another report containing a line chart of users over time (date for X, frequency for Y, grouped on user). I had hoped it would filter on the date range and the users from the bar chart. But although it filters on the users, it doesn't on the date range.

I'm using VA 7.4.

Re: Passing filters in linked reports

Sam_SAS — Tue, 19 May 2020 17:15:50 GMT

Hello,

VA 7.5 (and 8.x) has an option on report links named Set prompt bar values of target report. I believe this does what you are looking for.

Sam

Re: Passing filters in linked reports

Nigel_Pain — Wed, 20 May 2020 09:06:17 GMT

Thanks @Sam_SAS that looks like it would do the trick. As with several other issues, I'm going to have to look forward to upgrading to M6 and 7.5.

topic Re: Passing filters in linked reports in SAS Visual Analytics

Passing filters in linked reports

Re: Passing filters in linked reports

Re: Passing filters in linked reports