We have a dashboard that shows weekly sales figures and Year to date figures for a variety of products. To view weekly data we have a list object with week ending date that filters the different KPI's in the dashboard. We also use the chosen week ending date as a parameter to show applications data for the last 10 weeks.
The purpose of the list object with week ending date is to allow the user to look at data as of that week for the last 5 to 10 weeks but we also want the report to show the current week data when the user opens it. They can then use the list control object to look at different weeks if needed.
To set it automatically to the current week, we selected the 'initially select first item' check box in the options menu for the list object, but once we assign a parameter to this object, this option disappears.
Without parameter the option appears: screenshot below
After assigning the parameter,
This option is no longer available, screenshot below
Is there a solution to use this option simultaneously with a parameter?
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.