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.
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.
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.