Is it possible to dynamically set the date for last month in a slider
How to set the range dynamically is already described in the post beneath.
However I want to keep the full range and select per default the last month.
If you select an object on the report builder on the right side you have a panel in wich you have different section (Role, propertiety, classificatio, filter, ...)
On the classification you can choose for exaple the first ten value on a certain variable.
In your case you can set a filter (not a classification) for example
today() -30 < <your_ data_variable> < today()
You should find the filter thet more suite for you situation
This capability has been added to the latest release of VA running on the SAS 9 platform, VA 7.4. There are options now that allow for setting the slider range values to dynamic minimum and dynamic maximum, which would do exactly what you want. I'm not aware of any workarounds for releases prior to 7.4.
I need this also.
Can you give me more details on how I should do this ? I need the last 6 months to be selected. I will set the maximum value dynamic. So that solves the upper limit. But I can't get to set the lower limit correctly.
Thank you in advance.
I think there is some confusion in this thread about what the problem is that I'd like to try and clarify. And of course if I've misunderstood then please correct me.
First, it IS possible in Visual Analytics 7.4 to set a dynamic start and end point for range sliders so that whenever you open the report, the start and end points are the first and last dates in your data, respectively. This is what Renato is referring to.
I don't believe this is what Patrick is getting at though. Rather, it sounds like Patrick wants the range slider to automatically be set so the start and end point is the first and last date of the last month in the date range. So if my full range is January to November, I want the selected range to automatically be November 1st (the first date of the last month) to November 15th (the last date of the last month), while maintaining the earliest possible starting point as January 1st in the slider.
This is currently not possible.
The closest you could get is to set the end point to be dynamic (not the start point) and then manually adjusting the start point each time the month changes.
Alternatively, you could have a drop down list or something else for Month that filters the range slider, then use the dynamic start/end points in the range slider. So if you pick November in the drop down list, the range slider is automatically filtered for the first and last dates in the November range. I don't know if that makes sense for what you're doing though. And of course it still requires a user to do something to get the date ranges to what you want, as opposed to being purely automatic.
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.