12-16-2014 04:22 AM
I'm using SAS VA 6.4 and I'm willing to show the latest month available at the report's Range Slider.
For example, on the data, we have dates from Nov2013 until Dec2014. So, as Dec2014 is the last month available, I would like to show only Dec2014 (Interval end and beginning would be the same), then the user could slide to the previous months. Next month, when the data is refreshed, I would like to automatically display Jan2015, instead of Dec2014.
Does anyone has a clue on this?
Thanks in advance,
12-16-2014 04:41 AM
This is a topic that has been raised before in the thread - From here you will see that you can achieve the last 30 days with an expression in VA 6.4. (Modify the expression based on your requirements).
P.S. I'm curious to know whether you had searched to see if this was a question that had been previously raised?
12-16-2014 05:29 AM
Thanks for your reply... it is good to know what made you decide not to read the post... Perhaps as a community we need to be more vigilant to remind people to mark questions as "Answered" to help others in future.
12-16-2014 08:11 AM
After reading and testing the solution proposed at the other post, I saw that it did not satisfy my report needs: I'm looking for a way to show a specific range but allow the user to pick any interval available on the data being used, so basically, in my case, I would like to have a way to show only the last available month, without really filtering the data.